Form Design

G

Guest

I am new to Access and was asked to develop a form to be used for call
tracking purposes. I created a call entry form that requires the user to
select a call type from a combo box. There is one call type listed in the
combo box that will require the user to gather additional information about
the call. Can I design the form in a way that displays a group of additional
fields only if this one particular call type is selected?
 
G

Guest

If Me.cmbCallType = "the right value" then
me.txtField1.enabled = true
me.txtField2.enabled = true
end if

I believe you'll need to have this code in both the:
cmbCallType After Update
Form's On Current

In design view, make these fields DisAbled
me.txtField1.enabled
me.txtField2.enabled
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form/SubForm Design 3
Data entry to table from a form 1
Data entry VBA 1
Access Form - Lock Fields from Editing 0
Combo to select form then combo to select field for query 1
Data entry for a table from a form 2
Generic Functpon to Open a Form 2
Show dialog if there are no records in a form 2

Top