If then statement?

[natalie]

Hi,
I am setting up a new database and am unfamiliar with the technique needed
to do the following:
If a user inputs data into certain fields, then I want other fields to
display (on a form) based on the first selections. For instance, if they are
entering expenses for "hotel", then obviously things like conf rooms and
banquet lunch are only pertinent to "hotel" and not "car rental". How can I
set it up to make this happen?

 

[Tim Ferguson]

How can I
set it up to make this happen?

This is a forms design question, not a tables db design one (although I
suspect a tables design problem lies behind it). Anyway, to answer your
question, you should look at Help and the examples for the AfterUpdate and
BeforeUpdate events. Information on Enabled and Visible properties of
controls on forms would probably be appropriate too.

Hope that helps.


Tim F