Display data from Query into Form

[Sreedhart]

Hi,

I am quite new to Forms and equally novice to this Forum also. I am attaching the database dbtest.zip which contains a table, couple of queries and form.

I have done what ever settings I could after going thru some tutorials / discussion forums online, but to no avail.

All that I want is, when I open the form "frmtest" in "form view", and select CS in Combo 8, the corresponding fields in the form viz Item name, Sl No and System Name should get updated on the form. I want to view it in "Single Form" format.

I am not sure what else can go wrong here.
Kindly help
Regards.

[Missinglinq]

Here's a short tutorial on using the Combobox to retrieve Records:

If you haven't already done so, create a Form based on your Table or Query, including all the Fields you want displayed.

Then simply:

• Add a Combobox to your Form.
• The Combobox Wizard will pop up
• Select "Find a record based on the value I selected in my combobox."
• From the Table or Query the Form is based on, click on the Field you're searching by (a Field that is unique for each Record) to move it to the right side.
• Hit Next.
• Size the column appropriately.
• Hit Next.
• Name the Combobox something appropriate.
• Hit Finish.
  
  

Now you can drop the Combobox down and scroll down to the item to search by, or you can start to enter the item, and the Combobox will "autofill" as you type. Hit <Enter> and the Record will be retrieved.

Linq ;0)>

[Sreedhart]

Hi, I have tried following the steps you have written but still not much of help. Will appreciate if you do the necessary changes in the attached .zip file and send me back.

Many Thanks.

[June7]

1. tbltest does not have a single primary key field. All three fields are necessary to distinguish a unique record. This is a compound key. All three values will be needed to find specific record.

2. Combobox RowSource is a GROUP BY query. Cannot use this to search and filter for a specific record in tbltest. It can be used to filter for all records that are 'CS' or 'GS'.

Filtering can be done by parameterized query: http://datapigtechnologies.com/flash...tomfilter.html
This is the approach you have attempted. You are missing the VBA code in combobox AfterUpdate event to requery the form. Follow the referenced tutorial.

or

by setting form filter property or by moving to a record. Can allow wizard to build code for this approach. linq's post describes that.

[Sreedhart]

Hi, Thank you very much. It is working. the biggest mistake I was doing was to attach to the "control source" of the combo instead of "row source". Couple of other pointers were also quite helpful. For those who may face a similar kind of problem find attached the modified db.