microsoft access question

[tuccokeith]

Hello,

I have three tables. A Project table that contains project id, purpose, status, change indicator, and requestor name.

The second table is Change Project Table. This table is contains the Project Id, change date, and Change reason.


The third table is a Requestor name table. I use this table as a lookup table tied to requestor name. This table contains, a Requestor ID, Last Name, First Name, Department Number and Phone Extension.


I would like to create a dataentry form that will allow me to data-entry the Project Table fields. In addition I would like a sub-dataentry form to come up when the Change Indicator is set to "Yes".

How do I code a sub form to be displayed when Change Indicator is set to "Yes"?

 

[jdegeorge]

On the change indicator's AfterUpdate property, enter this code:

me.name.visible = false
docmd openform "frmNewForm"



Jim DeGeorge

 

[tuccokeith]

Hello,

in the code me.name.visible = false

should name equal my table table name?

I am receiving an invalid qualifier error

 

[jdegeorge]

Sorry. That's

Me!Name.Visible

Use it just as it is. "Me!Name" tells Access that you're talking about the current form with focus.

Jim DeGeorge

 

[tuccokeith]

Hello,

I have a question regarding whether or not I should use a query or a table.

I want the Change table to contain the following fields from a the Project table:

Project ID
Project Name

How do I link the tables so that these fields are only filled when the Change indicator is set to "true"?