Use combobox as field control in form. With RowSource like "1,'Cash',2,'Credit/Debit',3,'Check',4,'Deposit',5,'EFT'", BoundColumn = 1, ColumnCnt = 2, and ColumnWidths = "0,2.5".The reaason why i made that option with a hidden txtbox field to show the lable was i couldnt figure out how to just put the label in the table for this. I want to see if a transaction is Credit / Debit, Cash, and so on when i view the
account detail form and i didnt want the sub form to show a 1, 2, 3, 4 or 5.... I want it to show Cash, Credit/Debit, Check, Deposit, or EFT in that subform and i was unable to figure out how to put lable into a different table.
thank you so much! I made some changes, still have a few issues but working on them. I though about the case but have never done one before and wasnt ready for
an education, LOL..... but it worked great. I just have to re work some things and will let you know how it all works!
Thanks again!
Dave
Or create a table of those 5 payment types and use table as source for combobox. Or use an UNBOUND textbox with expression in ControlSource to convert number value to descriptive text. Don't need to save Method to table. Saving both MethodOpt and Method description is redundant.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I thought I mentioned that too but upon reviewing I see that I didn't.Saving both MethodOpt and Method description is redundant.
FWIW, I agree - don't save both. Furthermore, saving the option would not be my preferred approach. That would be to list options in a table as was mentioned, and relate the numeric PK option value as a FK value in the transactions table. I would also vote for the combo approach rather than coding for multiple buttons.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.