Force field to be filled out

[Kysteratwork]

Hi all,

I have a table tblCountry.

The user should be able to enter a new country in a pop-up (alerady created) which contains CountryID (autonumber), Country and Region (dropdown to tblRegion).

After the user enters Country, I want to force him to chose a region, too from the dropdown. So that he doesn't safe the entry without it.

How do I do that??

I reckon it's not too difficult, but I just can't figure it out...

Thanks a lot for any help.

Kysteratwork

 

[PHV]

Enforce all your validation rules in the BeforeUpdate event procedure of the Form playing with the MsgBox function, the SetFocus method and the Cancel argument.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Kysteratwork]

hmmm ... this appears to be more complicated than I thought. My knowledge on VB is very basic.

Would you have an example that I can refer to?

Kysteratwork