David Ball
Registered User.
- Local time
- Today, 22:07
- Joined
- Aug 9, 2010
- Messages
- 230
Hi,
I have a form frmContacts where a person’s name and address etc can be entered.
There are comboboxes for Country, State and City (in that order).
I want the State and City comboboxes to be not visible until a value is selected from the Country combo.
I have done this using,
Forms!frmContacts.Combo2.Visible = False
Forms!frmContacts.Combo4.Visible = False
,on the forms On Open event.
I then show the combos, as required, by using Forms!frmContacts.Combo2.Visible = True on first the Country combo’s After Update event, and then similar on the State combo to show the City combo.
The problem is that this hides the combos for all records, including the ones where a value has already been selected for all of these combos. I need to display these for records that already exist and only have them hidden when I scroll to the end of the list and onto next (blank) record.
I need something like an IF to test if there are values already.
How would I modify,
Forms!frmContacts.Combo2.Visible = False
Forms!frmContacts.Combo4.Visible = False
,to do this?
Thanks very much
Dave
I have a form frmContacts where a person’s name and address etc can be entered.
There are comboboxes for Country, State and City (in that order).
I want the State and City comboboxes to be not visible until a value is selected from the Country combo.
I have done this using,
Forms!frmContacts.Combo2.Visible = False
Forms!frmContacts.Combo4.Visible = False
,on the forms On Open event.
I then show the combos, as required, by using Forms!frmContacts.Combo2.Visible = True on first the Country combo’s After Update event, and then similar on the State combo to show the City combo.
The problem is that this hides the combos for all records, including the ones where a value has already been selected for all of these combos. I need to display these for records that already exist and only have them hidden when I scroll to the end of the list and onto next (blank) record.
I need something like an IF to test if there are values already.
How would I modify,
Forms!frmContacts.Combo2.Visible = False
Forms!frmContacts.Combo4.Visible = False
,to do this?
Thanks very much
Dave