Surely this is easy

[tmc]

Say I have a simple table with 2 fields JobNumber and
JobName.

I'd like a form that let's me view data in this table
where when I open the form it shows 2 blank controls
labeled Job Number and Job Name. When I enter a job
number in the Job Number control it should show the
corresponding JobName in the Job Name control.

Its important that I can enter a job number and not
scroll all the jobs or use the binoculars button to find
the record I'm looking for.

How do I do this without a lot of fancy code?

Thanks

 

[Jim/Chris]

Create a Combo Box on the form looking up job number. Make
sure you set in the properties "Autoexpand" to "Yes"

Jim

 

[Guest]

Any way to do it by typing the job number into the
control instead of scrolling thru combo box data?

 

[Jim/Chris]

if you enter the combo box and type the number it will auto
fill. Pressing enter will bring up the job. Only clicking
on the arrow will bring up a scroll list.

Jim

 

[robott]

This is a nice solution for a job I'm on right now - great! But, how do I bring up data using a field from a subform

I have a form showing address records; a subform shows multiple block/lots. Can I make a combo box that will call up the address record based on a block/lot entry?

 

[Albert D. Kallal]

since you already have the Job Number...then you don't need, nor want to
store/copy the description.

So, you can make a field that will display the job description for whatever
value you type into your job num.

Create a blank - un-bound text box. Call it JobDES

Then, you can for a expression type in:

=(dlookup("DescriptonFieldName","tableJobNumbers","[JobNumber] = " &
me.[JobNumber])

Thus, the above will lookup into the other table..and display the
value...you don't need to store it...

You can also actually base your form on a query...and then not even use any
code!