Thread: form/table question
06-16-06, 12:26 #1Registered User
- Join Date
- Feb 2006
Unanswered: form/table question
what is the best way in a form to show 5 payment types with associated text boxes where a person could add a dollar figure? I would like the underlying table to show 2 columns, payment type and payment rate. I need this so I could link this table by payment type to claims data that has a corresponding payment type field. I see combo and list boxes but really I would like the payment type field in the table to show up in the form (and can't be changed) next to the payment rate text box?
Is it possible?
This is the view in the underlying table.
Mental Health $0.00
Well Newborn $0.00
06-16-06, 13:17 #2Village Idiot
- Join Date
- Jul 2003
Your question is somewhat vague. I think what you are looking for is
to put 5 text boxes in which dollar values can be input, but the data is all
to be saved in one column in your table.
I would build an unbound form ( or at least that portion of it), and put a save button on it. The save button would then be coded to insert/update the values in the table.Inspiration Through Fermentation