Simple thing - form with associated data

[tweetyksc]

I usually design forms to view/export/mail reports, run things, etc. I'm doing this small project, should be a snap. But the simplest thing is holding me up, because I haven't done it in a while.

This database is pretty simple, with two tables.

-One table has the Customer's info (BP, Name, Area).
"BP" is the key (Cust number). This will be used as a lookup table.

-"Tracking" table is data entry table.
User will pull the BP number through lookup then other data; they can view all 3 fields from the BP table, but it stores the "BP" field.

Problem: I'm creating a form for them to use; when they pull the "BP" number, I want the other two fields (Name and area) from the underlying lookup table to appear so he can verify he's pulled the right one. I'd like to have this show up greyed out to the right. I know I've done this ages ago, but can't remember (not the disabling/greying out, being able to show this linked to the combo box).

I tried creating a query which pulls all the data together and show that on the form but then the dataset is not updatable.
I'm sure this is Access basics, but...help?

Some days I feel I'm going backward in my knowledge

 

[Fizzio]

Why not simply use a form/subform combination?

 

[FoFa]

You can link a DLOOKUP on the NAME and AREA fields to the combobox, and requery those controls after a name is selected. That would pull the info. in and still allow your form to be based on the other table, and you don't have to the subform route.

 

[tweetyksc]

Thanks for the tips - I didn't want to use DLookup or a subform though.

I found a solution by using the following -- in case anyone else is trying to accomplish the same thing.

In the text box that I want to use to display the name, I put the following, referring to the combo box that shows the number.

=[Forms]![Tracking]![cboBP].[Column](1)