Search results

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.

Hello, I have a a sub form within one of my forms to populate to fill out multiple records. I have a button command to have another sub form appear if it's needed for that record. However, once a selection is made in a combo box, this makes another sub form appear. There isn't any event...

With lots of questions!! I read books and have taken classes but they can't possibly prepare you for everything you come across building databases. I came here because this seemed like a really great resource. I live in Nashville, Tennessee. I love football (GO TITANS!!), enjoy cooking and...