Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding and modifying records

Status
Not open for further replies.

cdodson

IS-IT--Management
Apr 25, 2002
13
US
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
 
That should work to populate the second table, but if you need to populate several records simultaneously you would be better off using an append query with pointers to your original form & just calling that query from code.

Hope this helps... T
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top