Autofilling text box

[neideb]

Pls Help
I have a database where I update info of patients. In The first visit of a patient I input his weight and height in a form and save this info in a table. Next visit sometimes the weight and height are the same so I think I would have a module or procedure to check if this field has already been filled and replicate it to the new record and save in this new record and so forth. I already have tried many samples but still not succeeded. My experience in this matter is very little. Tks for your attention.

 

[Travis]

Try DLookUp

You can read about it in the Help file or on the MSN Knowledge base

 

[neideb]

Trevis, tks for your attention. I could get a module called autofillrecordfields. I had to make some changes but now it is working very well. Tks

 

[jwindon]

One more option, exspecially if you have many patients. DLookup becomes really slow.

Is your patient name part of a combobox? If it is, you can include the height and weight as part of the control source of the combo. You would then put two unbound controls on your form and on the afterupdate event of the combo, put the code:

Me.UnboundHeight=me.comboboxname.column(1)
Me.UnboundWeight=me.comboboxname.column(2)

The column numbers are representations of their place on the QB grid of the combo. They start with 0.