M
miamoe
Ok I am trying to write a macro where...
Each entry in our system is assigned a lead #. I open a form by the lead#,
enter information about the client and then there is a button to open another
form and schedule an appt (this form is linked to a different table). I want
to write a macro, that if we open this second form and the lead# field is
blank the lead# field is copied to the new form.
I know I can easily take care of this if all the information is in the same
table, but I don't want to do that since our database is large. And that has
casued problems in the past.
I am sure this is easy, but at this point my brain is fried....please help.
Each entry in our system is assigned a lead #. I open a form by the lead#,
enter information about the client and then there is a button to open another
form and schedule an appt (this form is linked to a different table). I want
to write a macro, that if we open this second form and the lead# field is
blank the lead# field is copied to the new form.
I know I can easily take care of this if all the information is in the same
table, but I don't want to do that since our database is large. And that has
casued problems in the past.
I am sure this is easy, but at this point my brain is fried....please help.