Form Design Question

[K Petroski]

I am new to Access and working on developing a new request tracking database
for our customer service team. The following two fields are required at the
table level when inputting a new request:

Field Name: SOURCE
ddl selections include: Call, email, web, fax

Field Name: REQUEST TYPE
ddl selections include: New, Edit, Dispute

Here's what I would like to do...If the user selects a REQUEST TYPE = to
"Dispute", make another group of required fields appear on the form to be
populated before saving the record. I know this can be done, just not sure
of the best wasy to approach it. Any suggestions would be appreciated.

 

[Bob Quintal]

I am new to Access and working on developing a new request
tracking database for our customer service team. The
following two fields are required at the table level when
inputting a new request:

Field Name: SOURCE
ddl selections include: Call, email, web, fax

Field Name: REQUEST TYPE
ddl selections include: New, Edit, Dispute

Here's what I would like to do...If the user selects a
REQUEST TYPE = to "Dispute", make another group of required
fields appear on the form to be populated before saving the
record. I know this can be done, just not sure of the best
wasy to approach it. Any suggestions would be appreciated.

Code the RequestType afterUpdate event:
[ControlA].Visible = [RequestType]= "Dispute"
[ControlB].Visible = [RequestType]= "Dispute"
[ControlC].Visible = etc...

Do this for each control you wish to be visible if Dispute is
entered, and not visible if it is not entered.

Then place the identical code in the form's Current event.

better yet, just call the afterUpdate Event from the current
Event.

 

[fredg]

I am new to Access and working on developing a new request tracking database
for our customer service team. The following two fields are required at the
table level when inputting a new request:

Field Name: SOURCE
ddl selections include: Call, email, web, fax

Field Name: REQUEST TYPE
ddl selections include: New, Edit, Dispute

Here's what I would like to do...If the user selects a REQUEST TYPE = to
"Dispute", make another group of required fields appear on the form to be
populated before saving the record. I know this can be done, just not sure
of the best wasy to approach it. Any suggestions would be appreciated.

Code the RequestType afterUpdate event:
[ControlA].Visible = [RequestType]= "Dispute"
[ControlB].Visible = [RequestType]= "Dispute"
[ControlC].Visible = etc...

Do this for each control you wish to be visible if Dispute is entered,
and not visible if it is not entered.

Then place the identical code in the form's Current event.

 

[Beetle]

It's hard to give you a specific answer without more info, but you are going
to need to be familiar with VBA code in order to accomplish what you want.

You would need some code in the After Update event of your REQUEST_TYPE
control to determine what other controls appear on the form based on the
selection made in REQUEST_TYPE.

Also, you would need to add a "Save" button to the form with code in the On
Click event that would prevent the record from saving if certain fields were
null.

If you're not familiar with VBA code, there are plenty of websites where you
could do some research. You won't get very far with Access without knowing
some VBA.