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

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.
 
L

Lord Kelvan

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
 
Top