Hi I am a real novice at code but was wondering if anyone could help.
I have a from called Forms Request with the following fields: Client (Combo Box), Address, Suburb, State, Post Code etc...
I also have a table called Client with the following fields: Client Id:, Client:, Street Address:, Suburb, Post Code etc....
What I want to achieve is when the Forms Request form is open and after Client field has been updated to have the Address Field, Suburb, State & Postcode (from the Client Table) to automatically fill in these fields. Is this possible???? I originally had a combo box for all these fields but as we have approx 3,000 clients to choose from it takes a long time to select.
Many Thanks in advance for your help.
I have a from called Forms Request with the following fields: Client (Combo Box), Address, Suburb, State, Post Code etc...
I also have a table called Client with the following fields: Client Id:, Client:, Street Address:, Suburb, Post Code etc....
What I want to achieve is when the Forms Request form is open and after Client field has been updated to have the Address Field, Suburb, State & Postcode (from the Client Table) to automatically fill in these fields. Is this possible???? I originally had a combo box for all these fields but as we have approx 3,000 clients to choose from it takes a long time to select.
Many Thanks in advance for your help.