I am trying to streamline my forms by just having one form that does two functions. My form is called frmInformation my textbox is called txtSerialNumber . On the form I have that Data entry function set to No. The primary function of the form is to check for current information. Instead of having another form just for entering new serial numbers. I want this form to do that function as well. So I need some code to check to see if the serial number...

thanks I'll try it

I am trying to add a record to multiple tables at the same time. My current Code created multiple records in the same table.

I am trying two different methods with no results:

Public Sub txtSerialNumber _Enter()

Dim txtLotNumber As String
Dim txtSerialNumber As String
'Dim db As Database
'Set db = OpenDatabase("M odem.mdb")
'Dim Tbl As Recordset
'Set Tbl = Modem.OpenRecor dset("TblLotNum ber",...

I have created a form to lookup components in a table. The problem I am having is the table I have has multiple designations in the same field. Ex CR2,CR4,CR18
If I am looking up a field that has one designation in it I am fine. But if the field has more than one designation in it, my Dlookup returns no information. Some of these fields have more than 50 designations in them. So I am trying to avoid creating new individual records. I will...