Hello all,
I'm a newbie to VBA programming so what I say here may not make sense. To best describe what I'm trying to accomplish I will use pseudocode:
1) Command Button Click Event: Search for record with the value of "CompanyName" and "FirstName" from frmImportForm
2) If record not found display an error message and exit sub
3) If record found, Open frmContacts and attach new value to "Group" field and prompt for any addtional values to be entered.
4) MoveNext
5) Open Import Form
Any ideas on how to accomplish this? I was thinking I may need a global Public Function to pass the values of Company Name and FirstName since I'm changing forms in the process. Any help would be appreciated.
Carey
I'm a newbie to VBA programming so what I say here may not make sense. To best describe what I'm trying to accomplish I will use pseudocode:
1) Command Button Click Event: Search for record with the value of "CompanyName" and "FirstName" from frmImportForm
2) If record not found display an error message and exit sub
3) If record found, Open frmContacts and attach new value to "Group" field and prompt for any addtional values to be entered.
4) MoveNext
5) Open Import Form
Any ideas on how to accomplish this? I was thinking I may need a global Public Function to pass the values of Company Name and FirstName since I'm changing forms in the process. Any help would be appreciated.
Carey