Related Record in second form

[WJReid]

Hi All,

I have a field in a form called SalesID. I would like to open, from a button, a second form with costs on it and I would like it to open at the same SalesID record. Can anyone tell me the code for this?

Regards,

Bill

 

[Russell Hauf]

Sure, something like this should work

DoCmd.OpenForm FormName:="MyFormName", WhereCondition:="[SalesID] = " & Me.txtSalesID

Where txtSalesID is the name of the text box where you have SalesID. If your ID is text, then you would change it to:

DoCmd.OpenForm FormName:="MyFormName", WhereCondition:="[SalesID] = '" & Me.txtSalesID & "'"

Note that you may also need to move the focus to the textbox before running the OpenForm method:

Me.txtSalesID.SetFocus

HTH,

Russell

 

[WJReid]

Thank you very much Russell.

Regards,

Bill

 

[WJReid]

Hi again Russell,

I guess I was just lucky the first time I ran the code, I was in record number 3 and it worked OK. Any other record, it opens the form at a new record. Any ideas?

Regards,

Bill

 

[Russell Hauf]

Can you post your code?

Thank you,

rh

 

[WJReid]

Hi Russell,

I shut the computer down last night, opened it up this morning and it was working OK. Thanks again for your help.

Regards,

Bill

 

[Russell Hauf]

Funny, that's the kind of advice that I get from our IT people at work!

"Try turning your computer off"

I think that since it works in about 1 out of 500 cases, it has made it to their "troubleshooting" guide.

 

[WJReid]

Nice to know that I'm only 1 in 500, makes me feel kind of important.

I used to get that kind of advice from IT as well, but I guess I won't be telling them that I did it and it worked, otherwise it will be first item in the manual.

Bill