-
IF statement or DoCmd ?
I have a subform called (Recocilation Account Budget >=5) that opens up in dataview sheet. I want the user to be able to open other records in other forms specifically when he/she DOUBLE CLICKS that row in subform (Recocilation Account Budget >=5) based on the following conditions in the column field [Budgetcategory] of the subform (Recocilation Account Budget >=5)
Some of the fields in the form are
Account BudgetCategory Voucher
These are the conditions:
If the BudgetCategory = 5, 7, 8 or 9 Open that specific record by Account in another form called Req Log
If the BudgetCategory = 6 Open that specific record by Account in another form called Travel
Thanks for your help. Im new at this
-
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC]
Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|