hello to one and all,
I am trying to transfer certain information (name, address_id)from one form to another. I have linked a command button to the other form via the wizard and it worked great (option: open the form and find specific data to display).
I've worked in the dlookup function to handle part of my issue.
Ok, when I click the button and a pre-existing Invoice form is located it is fine and dandy.
When the button is clicked on a record and no pre-existing info is found the new form comes up blank. What I want is for it to come up partially filled with the client's name.
On the new form I have a combo box which should be able to take in the client's last name or client's company but it won't pass it properly. I am however able to pass a string to another combo on the same form.
If anyone has suggestions / questions / comments please let me know asap.
Thanks in advance,
yammoo
P.S. I have no problem pasting the code if you need it.
I am trying to transfer certain information (name, address_id)from one form to another. I have linked a command button to the other form via the wizard and it worked great (option: open the form and find specific data to display).
I've worked in the dlookup function to handle part of my issue.
Ok, when I click the button and a pre-existing Invoice form is located it is fine and dandy.
When the button is clicked on a record and no pre-existing info is found the new form comes up blank. What I want is for it to come up partially filled with the client's name.
On the new form I have a combo box which should be able to take in the client's last name or client's company but it won't pass it properly. I am however able to pass a string to another combo on the same form.
If anyone has suggestions / questions / comments please let me know asap.
Thanks in advance,
yammoo
P.S. I have no problem pasting the code if you need it.