I am learning to program macros to make a dynamic form for my database. I have an address table called tblAddresses and a form called frmAddressEntry. One field of the table, RecType, can have the values of "O" or "I" for Organization or Individual. If the record is "O", then the fname (first name) field is blank, and the Organization Name is stored in the lname (lastname field). I want the form to appear with only the lname control visible, covering the fname control, if the RecType is "O", and both fname and lname visible if RecType is "I". Also, if the RecType is changed, the visible fields should change accordingly. How do I do this? I used to do this with a VisualBasic data entry program quite easily. Now I'm lost.
TIA, Matt Needles --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
