Getting a value from a query

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I have an input form tracks a van going from place to place. Each
record is given a unique visit number.

There is a [from] and [to] field on the form. How can I get the form to
automatically input the [from] filed with the data stored in the [to]
field of the previous record?

I created a query that has the correct data but I don't know how to get
the information from the query to the field on the form during data input.

Can anybody help?????
 
Main form / Sub form
In the main form have an unbound textbox that uses your query as record
source for the last "To."
Have sub form bound textbox for new record default form the main form.
[Forms]![YourMainForm]![YourTextBox]
 
You must log in or register to reply here.

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

Similar Threads

Parameter Value error in a Subform 0
InputBox within a query 4
Using the "Forms Object" on more than field in a query table 2
Query results in Form 3
Calculated field in a table 6
Launching a Form from Within a Form to Create a New Record 1
Parameter Query With Null Values 3
show a Query value in a form 9

Back
Top