Recent content by ndmark

Art - you're right. I must have changed something else that caused it to be a blank field. It's working great - thanks again.

Art - Thanks for your help. The only question I have is your instruction for Combo18 says to set column count to 1 but column width to nothing. When I did that, nothing showed up in the box, but after changing the width to 1" then the selections appeared. Did I do something wrong and got...

Attached is the modified database. Using just the one table, I just want to have a form that allows the user to fist pick the customer name and then the next combo box would only show the puchasedates for that customer. After the user selects the purchase date, the rest of the form would then...

That's the problem that I inherited - that all of the data is in one table. You're right that I'm having a problem with the queries as a result. Will post the database with the form by tomorrow, I just have to clean it up. That's why I was wondering if there was an example where all of the...

I can post the table but I have to make some changes to the customer names as the information is confidential. I will post it by tomorrow. Thanks again.

Bob - I took a look at your example and noticed that there were three different tables involved. Will it still work if there is only one table? This is the situation that I have. Thanks again for your help.

I'm relatively new to access and am having troubles designing a form that allows you to search a table. My table has 10 fields, including a custname field and datepurch field. Most custnames have made multiple purchases but only one purchase on any selected date. I'm trying to design a form...