Lookup form

I have a form that has a look up field. When a serial number is search the pcname and the owner are populated in a form. We add info in the notes text box and the form is saved to a history table. If the fields with the serial number and owner are not clicked on they are not saved in the history table. I can click on both of these fields and Access saves the data. Any ideas??

Not sure what your question is. If you click on both fields the data is
saved? You have to page up or page down to save the data unless you have
code on the form to do it.

What is your question?

Rick B

"Philip" wrote in message
...
I have a form that has a look up field. When a serial number is search the
pcname and the owner are populated in a form. We add info in the notes text
box and the form is saved to a history table. If the fields with the serial
number and owner are not clicked on they are not saved in the history table.
I can click on both of these fields and Access saves the data. Any ideas??

the look up field populates two other fields on the form (field1 and field2) which is pulled from Table A. after the notes field is filled out, field1 field 2 and the notes field is saved to Table B. If nothing by the notes field is clicked on then field1 and field2 are NOT saved. If I click on field 1 and field2 before saving then they are saved as well. What code do I use to get them to save without having to manually click on them?

On Tue, 8 Jun 2004 08:16:05 -0700, Philip
wrote:

the look up field populates two other fields on the form (field1 and field2) which is pulled from Table A. after the notes field is filled out, field1 field 2 and the notes field is saved to Table B. If nothing by the notes field is clicked on then field1 and field2 are NOT saved. If I click on field 1 and field2 before saving then they are saved as well. What code do I use to get them to save without having to manually click on them?

ummm... why would you want to store these fields redundantly in both
TableA and TableB in the first place!? It sounds like your table
design may be at fault here!

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

This is a rather simplified version of the problem. The root of the problem is the fact that the fields are not being saved with manually clicking on the them.