Form within a Form

[spinny]

Hi All,



I am very new to Access and am trying to build a database for recruiting. I have completed a lot of the database but am stuck with a few issues.

I have a main data input form that has an evaluation from that opens from there. The problem is that I cant figure out how to make the records match.

I.e if I select Suzie Smith on the Main data Form, when I click the Evaluation Form I want it to automatically go to whichever record I have selected on the Main data form.

If anyone could help me i would be very happy

Thanks

Andy

[RuralGuy]

Include a WHERE condition in your OpenForm command.

[spinny]

sorry if this is a dumb question but I am just using a macro to open the form - I have never used vb or any other programming language - is there any way to do it without using vb ?

thanks

[RuralGuy]

What version of Access are you using?

[spinny]

I am using Access 2003 but we have Access 2007 as well. I would prefer to use 2003....

[RuralGuy]

In the lower section of th4e design view of a macro is the WHERE Condition area. Does your RecordSource query/table have a unique field for Suzie Smith? If so then in the Where Condition area put [TheFieldName] = " & Me.ControlName that has the value in it from this form (if it is numeric. If text then:
[TheFieldName] = '" & Me.ControlName & "'"

[spinny]

Ok in terms of unique field you mean record number? I have an ID number in the field ID # - so for instance Suzie Smith is 2413. However, if Mandy Moore is selected - ID #1639 I need the same thing to happen.

I guess what I need is for all forms to recognize which record is selected in the Main data Form and open to that same record.

Thanks

Andy

[RuralGuy]

Then your WHERE condition is simply:
"[ID] = " & Me.[ID]
...using *your* control and field names of course.

[RuralGuy]

Andy,
If you are still having problems then maybe you can post your zipped up db on one of the free file hosting sites. BTW, it is not a good idea to have embedded spaces in a name or use the "#" character either. Just thought you'd like to know. Remove any sensitive data if you post the db.