jonathanchye
Registered User.
- Local time
- Today, 14:38
- Joined
- Mar 8, 2011
- Messages
- 448
I currently have a lot of textboxes in my form for users to key in values. I realised that some values might be the same for new forms so I have two questions :
1) Is using a combobox the only way to autofill values based on what users previously typed? Can this be done in a textbox as well? Asking this because too many comboboxes in the form won't look nice
2) If the unique ID of the field is a number and I create a new enquiry is there a possible way to search through the table and autofil all fields last entered releavant to the customer combobox regardless of unique ID?
For example ID1 is filled in with details relevant to ACME, ID2 is to BESTCO, ID3 ACME again, ID4 is NEWCO and now I create a new form ID5. When I select the customer combobox as ACME can I autofill the rest of the fields relevant to information I've filled in ID3?
I think basically I am looking for an improved Duplicate Record function where user can select which record to Duplicate and maybe which fields?
1) Is using a combobox the only way to autofill values based on what users previously typed? Can this be done in a textbox as well? Asking this because too many comboboxes in the form won't look nice
2) If the unique ID of the field is a number and I create a new enquiry is there a possible way to search through the table and autofil all fields last entered releavant to the customer combobox regardless of unique ID?
For example ID1 is filled in with details relevant to ACME, ID2 is to BESTCO, ID3 ACME again, ID4 is NEWCO and now I create a new form ID5. When I select the customer combobox as ACME can I autofill the rest of the fields relevant to information I've filled in ID3?
I think basically I am looking for an improved Duplicate Record function where user can select which record to Duplicate and maybe which fields?