Sub fields?

[richard]

When creating a field that is a list box, can I have other
fields created or expanded contingent on the selection
made? Is this possible through a function or would it have
to be coded?

Example:

If someone is filling the form and selects b, then 3 new
fields would "pop up".

 

[TKD Karen]

Yes, it would need to be coded in the listbox's After Update event. You
could use a Select Case statement or If Then Else to set whether or not the
3 new fields would be visible.

--
Karen Stern
A Little Help Computer Services, LLC
www.alittlehelp.net
(e-mail address removed)
518-885-4549
Everyone Needs A Little Help!

 

[richard]

I have never coded in Access, i do know basic programming,
but am unsure how to put the code within the form and how
to refer to the fields within the code. Do I have to do
something to the field or is there an inherent reference I
can make?