Userform where condition

[thingssocomplex]

I have a "Multiple Items" data form which lists a number of fields including a unique record ID for each row listed. I have created an hyperlink against each row which basically says "Open" the hyperlink opens another form. Both forms are created from query(s).

Normally I would enter the form/text box reference in the criteria of the relevant query. However because of the multiple unique ID's the query only returns the top/first entry.

Is it possible to open a user form and use the where condition to match the ID's to open the relevant record? If yes may I have a little direction please I've never used the where condition in a Macro before!

 

[vbaInet]

You can use a button instead and on the click event use the WHERE argument of the OpenForm method to open the form to the currently selected record's ID. Here's a link re this:

http://baldyweb.com/wherecondition.htm

 

[thingssocomplex]

Thank you very much I was missing the single quotes - I luv this site full of amazing talented and helpful people

 

[vbaInet]

Glad that worked for you. By the way, that site is run by pbaldy who's also a VIP member on here. You may have come across him.

 

[thingssocomplex]

I think I've seen the name before big thanks to pbaldy for setting up this wonderful froum

 

[vbaInet]

I think I've seen the name before big thanks to pbaldy for setting up this wonderful froum

Just for clarification, baldyweb.com (i.e. the site to which you were directed) is run by pbaldy and this forum is owned by someone else, not pbaldy