Hi,
I have a form with a number of text boxes which get their contents from a query (SELECT people.*,notes.goals FROM people,notes WHERE people.person_id = 1 AND notes.person_id = 1)...
I would like one of these text boxes (notes.goals) to include info about this persons goals when a new record is created - at the moment it is blank until I save and close the record before it appears then it works great. Maybe I need to use 2 different queries?
Hope this makes sense - any ideas?
Many thanks,
Trev
I have a form with a number of text boxes which get their contents from a query (SELECT people.*,notes.goals FROM people,notes WHERE people.person_id = 1 AND notes.person_id = 1)...
I would like one of these text boxes (notes.goals) to include info about this persons goals when a new record is created - at the moment it is blank until I save and close the record before it appears then it works great. Maybe I need to use 2 different queries?
Hope this makes sense - any ideas?
Many thanks,
Trev
