Update Certain form Fields

[lunchboxfl]

I have a form that we enter in a serial number of a piece of equiptment. That in return looks into a linked database called inventory to get the model of the machine. For some reason those records do not update until I go to the next record and then come back to this record then those fields will populate. I would like for those fields to update right after moving or tabbing out of the serial number field. Hope that makes sense.

 

[Kryst51]

What event are you using to trigger the update? Have you tried using the after update event of the serial number control?

 

[lunchboxfl]

I am learning this who access thing. Kind of thrown into the fire. I would like to use and after update command, but would like field 2 field 3 and field4 to update once serial is updated.

 

[DCrake]

If you are using a bound form then they should be updated automatically in the control but the actual record is not *saved" until you move the record pointer.

David

 

[lunchboxfl]

Yeah but in field 1 they enter a serial number field 2, 3, and 4, pull info based on that serial number from another database which works great, but until they click next to save that particular record and then back to come back to it fields 2, 3, and 4 are not updated. They want those fields to update right after entering the serial number and going through the rest of the form fields and not after the record is saved and then come back to it.