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
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.
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
Summary: I need a way to show a graph based table/query in MS Access form. I tried using OLE MS Graph and placed it in a form and then change rowsource to my table. But the graph generated in incorrect. I wa...
Summary: I have created a small access database with a form interface and would like to be able to update totals on a daily basis with as little effort as possible. I have received,stock on hand. issued out an...
Summary: I had MS Access 2.0 for a long time. Then I got MS Access 2000. There's one thing that bugs me about the newer version: when moving between a form's fields, I cannot add data by pressing the right arr...