I have looked thru previous posts but cannot seem to find the answer.
I have a form linked to several tables-uses unbound fields. tblTempChild is main form & holds child info until it is processed or deleted.
- cmdChild button goes to sub to add new child to tblTempChild.
- User gets a 2 msgbox asking for first & last names.
- I would like to search another table not associated with form(tblChild) to see if there is any record with that name:
- ask user if this is the child they want to process now, if no, show next, etc.
-If user says no to all records displayed, sub adds new record to tblTempChild.
Hope I have explained this right. I just can't figure out how to search & display records from the tblChild. Any help would be gratefully accepted.
I have a form linked to several tables-uses unbound fields. tblTempChild is main form & holds child info until it is processed or deleted.
- cmdChild button goes to sub to add new child to tblTempChild.
- User gets a 2 msgbox asking for first & last names.
- I would like to search another table not associated with form(tblChild) to see if there is any record with that name:
- ask user if this is the child they want to process now, if no, show next, etc.
-If user says no to all records displayed, sub adds new record to tblTempChild.
Hope I have explained this right. I just can't figure out how to search & display records from the tblChild. Any help would be gratefully accepted.
