J
jimcrowley
Hi! I've been tasked with creating a quick form for a database that
will go away in three months or so. What I want to do is:
1. On Form1 I want the user to enter data into Textbox1 which I have
bound to Table1.
2. I want to be able to check to see if the data entered in Textbox1
matches a a field in a record in Table2 and then update Textbox2,
Textbox3, etc with data from Table2.
3. If there is no record in Table2, then the user can enter data for
Textbox2, 3, 4, etc.
4. The user will also have to enter data in certain objects on the form
no matter what.
I realize that I should not house identical data in separate tables,
but this is temporary and I just need to get it done.
I'm not much of a programmer, but I am indeed stuck.
Could a kind soul (or even an unkind one?) please point me in the right
direction?
Thanks,
JC
will go away in three months or so. What I want to do is:
1. On Form1 I want the user to enter data into Textbox1 which I have
bound to Table1.
2. I want to be able to check to see if the data entered in Textbox1
matches a a field in a record in Table2 and then update Textbox2,
Textbox3, etc with data from Table2.
3. If there is no record in Table2, then the user can enter data for
Textbox2, 3, 4, etc.
4. The user will also have to enter data in certain objects on the form
no matter what.
I realize that I should not house identical data in separate tables,
but this is temporary and I just need to get it done.
I'm not much of a programmer, but I am indeed stuck.
Could a kind soul (or even an unkind one?) please point me in the right
direction?
Thanks,
JC