Combo boxes

[Guest]

I am trying to make a form that pulls up a job name when a user inputs a job
number. I tried using a combo box and text box which works great for one
record. If I push the navigationb button to the next record, it displays the
same job name and number from the first record. If I change the second
record, it will also replace the first. Can you help?

 

[Al Camp]

Is your combo "bound" to the JobID field? It should be, so it saves the
JobID on each record.

Put the JobID in the first column, and JobName in the second.

In an "unbound" TextControl (ex. [JobName]) put a ControlSource of...
= YourCombo.Column(1)
Combo columns are numbered 0, 1, 2, etc... so this calculated field will
display the JobName all the time... even as you move from one rec to
another.

hth
Al Camp

 

[Van T. Dinh]

If you use the usual "Navigation" ComboBox then your ComboBox is unbound
which won't be changed when you move to the next Record (using Navigation
Bar).

Use the Form_Current Event to set the value of this unbound ComboBox.