How to populate a field in a new form

[Bigmo2u]

I have attached a sample of my DB so you can see for yourself what i am trying to do. I want to capture the SSN on the search page so when I go to P1 or P2 that persons info is all ready populated on the right side of the page, but still allows for a search after I have updated the record.

Any help is greatly appreciated.

 

[carash77ash]

i don't quite understand what you are trying to do.

Do you want the form p1 or p2 to open when you select the ssn or do you want it to appear on the search page.

Ash

 

[Sergeant]

I must admit, I'm not clear either on what it is you want to do. Please clarify.

 

[Bigmo2u]

Sorry about that guys. If on the search page you click on a person and it populates the info on the right. If there is anyway if you click the radio button it captures the the persons SSN and when you go to P1 or P2 that persons info is already populated on the right side of the page. At minimum it copies the SSN and places it in the search box at the top of the page. I hope this helps a little.

Thanks

 

[Pat Hartman]

When you open a form with the OpenForm method, provide criteria to limit the records displayed by supplying the where argument.

 

[Bigmo2u]

Pat - can you give me a little help on how to write that argument? Please.

 

[carash77ash]

when you set up a command button to open form (with wizard) you can set the link criteria. Why write code when access will do it for you.

Ash

 

[Bigmo2u]

Thanks, I will give that a try and post tomorrow if I have any problems.

 

[Bigmo2u]

Okay using the wizard worked great to carry the SSN over, but it won't allow me to click on other members in the P1 Form. How do I get the P1 form to go back to being able to search for other members in that form? You might have multiple claims to enter on the same form. The only way I could get the form to refresh is to close and re-open the form, but that seems like the long way to get the results I want.

I am sure you guys think this a simple fix.

 

[Pat Hartman]

You need a separate, unbound combo for searching. The combo that is bound to the table cannot do double duty.

 

[Bigmo2u]

okay. Thanks for your help guys.