Automatically Populating fields from a Table to a Form...

  • Thread starter Thread starter J R Thompson
  • Start date Start date
J

J R Thompson

I'm creating a scheduling system and would like end users to enter a last
name in a form and have all the patient demographics associated with that
last name to be filled in automatically - not sure how to set this up, I know
this is set up using a query but not sure how to make it set up in a form.
 
post your query in microsoft.public.access.forms but basically you
have use a on click event for an ok button or something to run a dao
query to select the information and then fill in the fields eg
txtbox.value = rst.valuefordisplay

look up dao recordsets for that and it should explain what you are
trying to do or ask on microsoft.public.access.forms

these links may help

http://www.allenbrowne.com/ser-29.html

regards
kelvan
 

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

using a calculation in a query 8
Pop up form is not populating query results 0
Access Automatically Send a notification email once a record is added 0
"Data Has Been Changed" error with MSSQL 2005 backend using left j 1
Auto populate controls on a form 4
Creating database and wish to automate 4
Count text values in a Access Field 0
returning dates in a query 2

Back
Top