ny1994rangers
New member
- Local time
- Today, 10:35
- Joined
- Mar 28, 2012
- Messages
- 3
I'm new to Access so I apologize if I've done something drastically wrong.
Currently I have a search form that populates a listbox. I did some digging online and found code that when you doubleclick a line item in teh listbox, it looks at the ID # of the item, and opens up a data entry form and goes right to that ID #. That code is:
DoCmd.OpenForm "Add/Update Inquiries", , , "[ID]=" & Me.List93
List93 is the name of the listbox.
Another field that is populated in the listbox is [Record Type]. How can I change that code to open "Add/Update Inquiries" if the Record Type is "Inquiry" and to open "Data Management" if the Record Type is "Data Management"
Thanks for any help.
Currently I have a search form that populates a listbox. I did some digging online and found code that when you doubleclick a line item in teh listbox, it looks at the ID # of the item, and opens up a data entry form and goes right to that ID #. That code is:
DoCmd.OpenForm "Add/Update Inquiries", , , "[ID]=" & Me.List93
List93 is the name of the listbox.
Another field that is populated in the listbox is [Record Type]. How can I change that code to open "Add/Update Inquiries" if the Record Type is "Inquiry" and to open "Data Management" if the Record Type is "Data Management"
Thanks for any help.