Assigning specific record data to fields on a form Access 2003

A

AccessWimp

This is driving me nuts becuase I know I have done it before. I have
a recordset that has a column with "locations". Each of the se
locations is supposed to aid a user in figuring out where parts are in
a physical drawer. I am trying to make a form that accurately
reflects the way the drawer is laid out, based on these "locations".
I thought I could use some code like, IIf [Location] = * ,
PartNumber, "No Part Number"

This works, except it is only showing one result at a time, even
though I have a lot of different text boxes, each with a different
"location"

Example:
Result I am looking for:

IIf [Location] = 1A , PartNumber, "No Part Number" Part
Number corresponding to location 1A
IIf [Location] = 1B , PartNumber, "No Part Number" Part
Number corresponding to location 1B
IIf [Location] = 1C , PartNumber, "No Part Number" Part
Number corresponding to location 1C
IIf [Location] = 1D , PartNumber, "No Part Number" Part
Number corresponding to location 1D


What I am getting

Part Number corresponding to location 1A

No Part Number

No Part Number

No Part Number

If I scroll the mouse wheel, then the next record shows up in its
corresponding text box... I just want them to all show up on one
form. Any help is GREATLY appreciated. This is really bugging me!!!
Thanks :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Copy previous record into form field 0
Create a form to represent inventory drawer locations 0
If datapoint already exists populate form 2
This record has been changed by another user since you started edi 4
Query record in SQL 4
Formula For Sorting Part Numbers 1
IIf statement on a report control source 2

Top