Computing.Net > Forums > Database > Access - Form Control for field

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Access - Form Control for field

Reply to Message Icon

Name: cathy
Date: May 18, 2006 at 21:00:56 Pacific
OS: Windows XP
CPU/Ram: Intel Pentium
Product: Toshiba
Comment:

I want to be able to display the data in a record of a particular field -in a drop down list - when in DS view. I have created a DB for a lingerie company and sizes differ for different items. When recording an order for a specific item I want to be able to chose one of the available corresponding sizes from a list.

computerlady



Sponsored Link
Ads by Google

Response Number 1
Name: seawatch
Date: June 2, 2006 at 14:46:11 Pacific
Reply:

You could use a List Box or a Combo Box.

Is that what you are after?

Today seems like a good day to chew through the restraints.


0

Response Number 2
Name: cathy
Date: June 4, 2006 at 23:12:56 Pacific
Reply:

Not that simple. I am on a subform in datasheet view. For any particular item I need the available sizes. This varies from one item number to another. A list box or combo taken from the relevant table would give the list of size ranges for each record not just those sizes specific to a particular record. At the moment I have a anotherlittle linked subform on the mainsubform that is shown over the datasheet when the + is clicked and shows the sizes that are available for that item. However that does not allow a user to choose a size from it.

computerlady


0

Response Number 3
Name: seawatch
Date: June 5, 2006 at 05:45:09 Pacific
Reply:

You may have to do this by runnig a query in the background. But to be honest, I'm in over my head.

Maybe Jennifer Sumn or Bryco or one of the other wizards around here will pick up on this thread and offer a solution.

Larry

Today seems like a good day to chew through the restraints.


0

Response Number 4
Name: cathy
Date: June 6, 2006 at 16:20:48 Pacific
Reply:

Thanks anyway. Will see if anyone else picks up on this.
Cathy

computerlady


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: Access - Form Control for field

MS Graph in Access Form www.computing.net/answers/dbase/ms-graph-in-access-form/183.html

access forms help www.computing.net/answers/dbase/access-forms-help/125.html

MS Access 2000 annoys me www.computing.net/answers/dbase/ms-access-2000-annoys-me/104.html