Recent content by LDeBlois

Yes, I think this is what I want to do. So, I should set the Limit to List Property to Yes, and in the On Not in List event, I am assuming I need to run a macro to add the new record to table1? I don't know the code to write, so I tried the Macro Builder but I don't see and AutoAdd function...

I have a form where I placed 2 (cascading) combos in the header. The 1stcombo reviews Table1, and the 2ndcombo from Table2. The detail section is also from Table2. My problem is, if I need to add a new record, I can't do it through the header (right)? I can add a record in the detail...

Thanks for the reply. I saw the code you gave me, but I don't know where to put it or how to tell it to display the comment box only when NO is selected. Can you help a little more?

I have a field on my form which allows the user to select "Yes" or "No". Is there a way to have a "Comments" box appear if the user selects "No"?

I must be doing something wrong. I used a combo box to enter a name (& at the same time check to see if it already exists). Now when I view my records, they all have a blank space for the last name, & when I select a last name, it makes all the records have that same last name. (I'm pretty green...

Novice here! I am trying to set up a database to store names of Temporary Employees. I want the user to be able to use a form to enter their data, and have the capability of viewing if the name already exists in the database. The purpose is to allow us to see if a temp has already been here...