Matt Needles wrote:

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
I have an example creating a form both using the GUI and using a macro in http://www.pitonyak.org/database/AndrewBase.odt
The section title is "Create a form"

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info:  http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to