setting up a query

[smorr]

I have been designing forms in InfoPath which are connected to an Access
database. How does one go about setting up a query whereby info from one
record (in the database) is inserted automatically in a form?

 

[S.Y.M. Wong-A-Ton]

You can drag the group node from the dataFields section in the "Data Source"
pane and drop it on the form in the data fields section and select "Repeating
section with controls" from the context menu that appears. Then double-click
on the repeating section, select the "Display" tab, and then the "Filter
Data" button to set up a filter that uses a field from the query fields
section (you need to add fields to this section to set up the fields to query
on) to filter the data down to 1 record.

 

[smorr]

Thanks for the help. This worked.
--
smorr

You can drag the group node from the dataFields section in the "Data Source"
pane and drop it on the form in the data fields section and select "Repeating
section with controls" from the context menu that appears. Then double-click
on the repeating section, select the "Display" tab, and then the "Filter
Data" button to set up a filter that uses a field from the query fields
section (you need to add fields to this section to set up the fields to query
on) to filter the data down to 1 record.

 

[S.Y.M. Wong-A-Ton]

You're welcome.
---
S.Y.M. Wong-A-Ton

Thanks for the help. This worked.