Populate form field with value from query

[crowley131]

Hi Everyone,

Hope someone can help with this.

I am trying to calculate the keystage and year group of pupils on my database. I have created queries that successfully calculate the data, but I cant work out how to add the results from my queries into an already created form. I thought I could use DLookup, but this just populates with a random value from the data and not the value for that particular pupil.

Thank you in advance for you help

C

 

[bob fitz]

You don't say, but I'm guessing that the form is unbound, so perhaps you just need to set the Record Source property of the form to the name of the query and then the Control Source property of each control to a field in the query.

 

[crowley131]

Hi bob,

The form is bound to a table (pupilPersonalDetails). Should I be looking at populating a field in the table with the query results instead?

Thanks

C

 

[bob fitz]

Assuming that the form controls are to be populated be the data in the table that the form is bound to, you just need to set the Control Source property of each control to a field in the table.