Recent content by Somullins

Thank you both for the quick responses.

I have a database and I need help with how best to get the results. This has a customer number with the customers information and plan type. The customer can only have one plan type per customer number. How can I build a query that pulls the records that have the same customer number but...

Hello, I have a form with a yes/no combo box. If the user enters yes, they are to use a command button to enter detail to the question. Can I disable the button if they select no? If so, how? Thanks!

I found it! There was a command button hiding behind the subform. I was missing it thinking it was the code for the command button I built. Thank you so much for all your help!!

Where is the word File being used? I changed the Data Entry Properties back to no, changed all of my naming conventions and set my Primary Key to an auto number as you suggested. I appreciate all of your help. This is a hand me down project that a co-worker left the company and didn't...

Okay here it is finally

Trying this again

Sorry about that. Here is the 2003 version

I am in the process of setting up now. If you don't mind, please send me the steps in case I have trouble. Also, will this combox show the subform data as well? Will I need to build a second one in the subform?

Here is the db. I could have completely overlooked it.

I searched the whole project.

I guess that I could. I thought it would get to be difficult to search as the database grows.

By customer number which is the primary key. This is also a field for both tables.

I have built a database where other users will be entering the data. The data entry form has a subform with data from another table. The main form is a constant (customer information) but the subform is for each transaction being recorded. I want to be able to create a record search and...

I searched the entire module and couldn't find any code.