If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If then statement?
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? |
#2
|
|||
|
|||
If then statement?
=?Utf-8?B?bmF0YWxpZQ==?= wrote in
: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Syntax error in INSERT INTO Statement | Hemil | Running & Setting Up Queries | 2 | April 5th, 2005 09:55 PM |
SQL Statement created from ItemsSelected from Several Listboxes.. | Denis Bisson | Using Forms | 2 | February 21st, 2005 02:48 AM |
Executing 'Transform' SQL in VBA | Leo | General Discussion | 20 | October 28th, 2004 10:42 AM |
Calculated Mean | Charles Deng | Running & Setting Up Queries | 21 | October 15th, 2004 08:37 PM |
If statement | Doug | Worksheet Functions | 4 | June 25th, 2004 01:42 PM |