Autofill a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I’ve searched through the Q&A here for an answer to autofill a form but could
not find an answer for my dilemma,
I’m looking to autofill a form from a table named Requests. I want to type
in a Record number in a field and have the record display to a form.
I created a form with its control source set to a table (Requests)
On this form I put an unbound textbox named [GetRec] this textbox after
update property is set to run a macro GetUpdateRec.
GetUpdatrRec Macro Design is:
GoToControl; [ReqID]
FindRecord: =[GetRec]
GoToControl: [GetRec]
This seems to work but I think it’s a little Rube Goldberg, is there an
easer or better way to call up a record?
Thanks for any help – Terry
 
Yes I tried using a Combo box but I can't get it to work

Chris Reveille said:
Have you tried using a ComboBox?

Chris
-----Original Message-----
Iâ?Tve searched through the Q&A here for an answer to autofill a form but could
not find an answer for my dilemma,
Iâ?Tm looking to autofill a form from a table named Requests. I want to type
in a Record number in a field and have the record display to a form.
I created a form with its control source set to a table (Requests)
On this form I put an unbound textbox named [GetRec] this textbox after
update property is set to run a macro GetUpdateRec.
GetUpdatrRec Macro Design is:
GoToControl; [ReqID]
FindRecord: =[GetRec]
GoToControl: [GetRec]
This seems to work but I think itâ?Ts a little Rube Goldberg, is there an
easer or better way to call up a record?
Thanks for any help â?" Terry

.
Click to expand...
Click to expand...
 
Back
Top