Search results

PBaldy, I got it. i was using the wrong sintax. I took your advise i left the field, but i am using the new one for reporting. Thanks for all your help!

Combine two fields in a table Pbaldy, Thanks for your response, but i can not get it to work. i try combining the First Name and Middle Name fields into Full Names but i am getting a value of -1 in the Full Names field. I must be using the wrong syntax in the criteria. Do you have any...

Open Form from Sub-Form PBaldy, Thanks for your suggestion. It worked! Now, I am able to open a form from the subform. Thanks again. :)

Merge two fields in a table PBALDY, Thanks for your response. I am looking to eliminate the Frist Name and Last Name fields in the table and replace it with the full name. Is that possible? As i mentioned earlier i already have 50,000 records entered so i do no want to re-type them again...

All, I have a table with about 50,000 records. In the table I have a First Name and Middle Name field. I have created a third field called FULL NAMES. PROBLEM: How do i combine the data from First Name and Middle Name fields into the FULL Names field in the same table. Thanks for your help!

All, This is my issue. I have a main form and a sub-form. In the main form i enter a search criteria and all the records that meet it are display in the sub form. This works like a charm! PROBLEM: How do i display the full record from the sub-form into another form by just clicking on...