Surely this is easy

  • Thread starter Thread starter tmc
  • Start date Start date
T

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
 
Create a Combo Box on the form looking up job number. Make
sure you set in the properties "Autoexpand" to "Yes"

Jim
 
Any way to do it by typing the job number into the
control instead of scrolling thru combo box data?
 
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
 
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?
 
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!
 
Back
Top