Opening a form for a particular record.

[86rainey]

Hi everyone.

I'm new to access so please bear with me!

I have a Database to store people's names and payments they have made. I have a table to store information about each. One person can have many payments and I've created such a relationship. I have a form that displays certain groups of people. I would like to have a command button beside each name that would open a form with their relevent payment records. I can get the payments form open but not the matching record. Any idea how to do this?

Any help or guidance would be great!

[June7]

Show the code you use to open the form. Is it a macro or VBA? Are you using DoCmd.OpenForm? Use the WHERE CONDITION argument of th OpenForm method, something like: "ClientID=" & Me.ClientID

[86rainey]

This is the code I'm using:

DoCmd.OpenForm "Inv_Payments", , , "SQA_Number = " & Me.SQA_Number

Clicking the button gives me an InputBox, looking for the SQA_Number. I want it to take the current SQA number and open the matching record from another table.

[June7]

Is SQA_Number a number or text field? If text, need apostrophe delimiters:

"SQA_Number = '" & Me.SQA_Number & "'"

I don't understand why you are getting an input prompt. That indicates to me a query input parameter. If VBA could not find Me.SQA_Number, should trigger an error message, not an input prompt.

[Missinglinq]

...I don't understand why you are getting an input prompt. That indicates to me a query input parameter. If VBA could not find Me.SQA_Number, should trigger an error message, not an input prompt.

I used to think that, too, but in actuality, Access will do this if SQA_Number doesn't exist on the Form named Inv_Payments!

It may simply not exist or it could be spelled differently on the Form being opened.

Linq ;0)>

[86rainey]

SQA_Number is a field on the first form, Class_List, and is also present on the second, Inv_Payments. Both forms are tables, SQA_Number is the primary key in Class_List and the foreign key in Inv_Payments.

The data type for SQA_Number is number. I added in a MSGBOX to tell me what value is stored in SQA_Number when I press the command button. The number matches the current record in form 1 (Class_List), but the second form (Inv_Payments) still opens at record 1.

[Missinglinq]

SQA_Number is a field on the first form, Class_List, and is also present on the second, Inv_Payments. Both forms are tables, SQA_Number is the primary key in Class_List and the foreign key in Inv_Payments.

A couple of things:

Both forms are tables makes no sense! Forms aren't Tables! Perhaps you meant that both Forms were directly based on Tables?

Also, vis a vis SQA_Number is the primary key in Class_List and the foreign key in Inv_Payments; Forms do not have Primary Keys or Foreign Keys, Tables do! This is not just being picky about terminology, you need to have at least a basic understanding of these things to do this kind of work.

That said, something is simply not right, here! Are you sure that
SQA_Number is on the Inv_Payments Form, as opposed to simply being in the Table?

I see no way we can help you further unless you can Zip up your file and attach it to a post so that we can look at it. The instructions for doing this are at the bottom of June7's post.

Linq ;0)>