Open another Form/query based on a field

Hey guys,

Not sure if I'm missing something here, I've tried almost every combination to get this to work.

I have an Access 2007 database, linked to a SharePoint 2007 site. I have created a form that works well. One of the reasons I created this database was to use it as a front end for the users to simplify data entry. I have created a VBA macro that should read the "Facility" number (in text format) and then open another form to provide the minor details of that particular facility, ie. address, state etc.

Ideally I'd prefer it to auto-populate the fields in the form for entry in to SharePoint (as a big limitation of SharePoint 2007 is linked fields, hence why I'm using Access), but am not having much luck there either, so happy for it to open another form to display this information to the user so they can manually enter the information in to the original form.

What happens when I click on the button though is I get a dialog box and if I enter the facility number I get the corresponding record. But it doesn't appear to be reading it from the form with SharePoint data. I'm hoping it's something simple, but below is the code for my button.

Please Login or Register  to view this content.

I've also tried:

Please Login or Register  to view this content.

And various other methods with no luck.

Hope I made sense about what I'm trying to do. All fields are text fields.

Cheers.

Finally figured it out, due to the field being a text box, I originally had too few quotation marks. Solved it by:

Please Login or Register  to view this content.