Form Based upon a One to One Relationship table that always shows first record?

[d9pierce1]

Hi all,
I have put a sample db for this together due to size issues and uploads which I have attached. I created a one to one relationship between the two tables and when I click on my button to open the form, it always goes to first record, not what I want at all. It should give me the record that is with the open form (PersonFrm) PersonID. I have tried everything under the sun that I can come up with in my small mind to solve this. Basically it is a button to open a form to display extended info from a person. Should be simple I would have guessed but not. If someone could take a look as the form should only have one record per person. I had to take some samples from my main db as its to big to upload here so has some code that doesn't belong but don't interfer with what I am trying to accomplish. Would appreciate it if one of you could take a look and let me know what it is I am doing wrong with this one to one relationship?
Thanks


Dave

Some Data.zip

[pbaldy]

Sounds like you want this:

http://www.baldyweb.com/wherecondition.htm

[d9pierce1]

Hi and thanks however I am getting an error ? Type Mismatch
DoCmd.OpenForm "PersonExtInfoFrm", , , "PersonID = '" & Me.PersonID & "'"

[pbaldy]

PersonID is a numeric field, is it not? You want the first syntax, without the ' delimiters.

[d9pierce1]

Thanks, that worked but something is wrong? I get a blank form (No fileds) when I go to a record that doesn't have an existing record in it? Blanks out the entire form.

[d9pierce1]

Thanks
I figured out, had set to no additions somehow? Must have done by mistake
Thanks again!
Dave

[pbaldy]

Happy to help Dave!

[d9pierce1]

thanks a lot, I love this site