Hi,
I have a form with a number of fields on it. When the form is first created, a few of these fields are 'required' in the table definition. However, users will come back later & add further information into the form. I need to set a lot of rules around the fields to force the users to enter all required information. e.g. they can't enter 'offer 2' information until all 'offer 1' information has been entered. I tried to create a macro on the 'before event' of offer 2, but it didn't work because it's on the 'before event' you then can't navigate to the 'offer 1' field. I can use msgbox, to warn, but I really need to require the data entry rather than just warn. Any suggestions?
By the way, I'm not good with VBA!