Show query result in a form (1 Viewer)

thedeadzeds · Feb 13, 2018

Guys,

Is there a way to link results from a query into a form?

I have a query named "Remaining" and field within that query named "Days Remaining" which is an expression. I would like to see this in a form is possible?

Hope this makes sense?

arnelgp · Feb 13, 2018

add an unbound textbox on your form.
on its record source, put:

=Dlookup("[Days Remaining]", "Remaining")

plog · Feb 13, 2018

arnel's method will display 1 value in an input on your form. To show multiple values you will need a sub-form. It would be based on your query and a continous form.

thedeadzeds · Feb 13, 2018

Thank you both, I should have also said that i want the Dlookup result to show based on the whatever name is selected in the drop down in the form called "Name" Is this possible or do i need to provide more info? Sorry, I'm still relatively new to access

arnelgp · Feb 13, 2018

just add the combo to your lookup as criteria:

=Dlookup("[Days Remaining]", "Remaining", "[NameField]='" & [Name] & "'")

then on the AfterUpdate Event of you Name combobox, requery the unbound textbox.

Private Sub Name_AfterUpdate()
Me.UnboundTextboxName.Requery
End Sub

thedeadzeds · Feb 13, 2018

Thanks arnelgp, i'm getting an error message in my form. I've attached the database. Any chance you could have a look? Sorry about this

arnelgp · Feb 13, 2018

check this one please

thedeadzeds · Feb 13, 2018

Amazing thank you so much

Show query result in a form (1 Viewer)

thedeadzeds

Registered User.

Attachments

arnelgp

..forever waiting... waiting for jellybean!

plog

Banishment Pending

thedeadzeds

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

thedeadzeds

Registered User.

Attachments

arnelgp

..forever waiting... waiting for jellybean!

Attachments

thedeadzeds

Registered User.

Similar threads

Users who are viewing this thread