Form Design Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

K Petroski - 05 Jul 2007 23:04 GMT

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.

Reply to this Message

fredg - 05 Jul 2007 23:51 GMT

> 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
[quoted text clipped - 10 lines]
> 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.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Bob Quintal - 05 Jul 2007 23:10 GMT

>> I am new to Access and working on developing a new request
>> tracking database for our customer service team. The
[quoted text clipped - 22 lines]
>
> Then place the identical code in the form's Current event.

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

Signature

Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Reply to this Message

Beetle - 06 Jul 2007 00:00 GMT

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.

Reply to this Message