Access - Form Control for field

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

Access - Form Control for field

Original Message

Name: cathy
Date: May 18, 2006 at 21:00:56 Pacific
Subject: Access - Form Control for field
OS: Windows XP
CPU/Ram: Intel Pentium
Model/Manufacturer: 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

Report Offensive Message For Removal

Response Number 1

Name: seawatch
Date: June 2, 2006 at 14:46:11 Pacific

Reply: (edit)

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.

Report Offensive Follow Up For Removal

Response Number 2

Name: cathy
Date: June 4, 2006 at 23:12:56 Pacific

Reply: (edit)

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

Report Offensive Follow Up For Removal

Response Number 3

Name: seawatch
Date: June 5, 2006 at 05:45:09 Pacific

Reply: (edit)

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.

Report Offensive Follow Up For Removal

Response Number 4

Name: cathy
Date: June 6, 2006 at 16:20:48 Pacific

Reply: (edit)

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

Report Offensive Follow Up For Removal


MS Graph in Access Form MS Access 2000 annoys me access forms help Field Question Field auto-update in form	Access Query to Merge with Word Doc Scroll Bars on Access Form Access 2003 field extraction issue access form yes/no check box From Design Problem

SQL DB Owner

SQL *Plus Help

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: Access - Form Control for field

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

Have you ever used OpenOffice?

Poll Finishes In 5 Days.
Discuss in The Lounge

Old (~P1) Case LED Screen - setting

Better Motherboard

Please help, new build wont turn on

CD Rom, mouse & keyboard not workin

Dell CPi display drivers

All Posts Awaiting Replies