Autofill a form

[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

 

[Chris Reveille]

Have you tried using a ComboBox?

Chris

 

[Guest]

Yes I tried using a Combo box but I can't get it to work

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

.