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 PS: The form controls for the three fields are txtRecType, txtLname, txtFname. The lname and fname controls are on the same line, usually lname follows fname, separated by about 5mm of space. lname can contain 40 chars and fname 30 chars, so they are about 5cm wide in "I" mode. The lname field should be about 8cm wide in "O" mode. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
