InfoPath, Access Database, & Multiple Views

R

ridawg

Hey,

I'm trying to create an InfoPath form that works with an Access Database.
This is the Plan:

Default View (Search) - This view includes several fields to search against
the database and returns about 5 fields plus a button called Details that
will take you to a view called Details that displays all the fields for the
selected record for updating.

Details View - all the fields are displayed for editing.

New Record View - Same as the details view but all the fields would be blank.

I've created the Search view and it's working great. The problem I'm having
is when I click the Details button instead of seeing just the record I
selected I'm seeing all the records in the database. I've created a tempID
field and set the value of it to the Rec_ID by creating a rule for the
Details button. But I can't seem to figure out how to match up the tempID and
Rec_ID to only display the selected record in my Details view.

I haven't had much luck finding an example of how to do this so any help
would be much appreciated!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top