Recent content by sargturner

Yeah that is my exact problem... based my cb off my query so I would show the dates instead of IDs and it works great... butt theres still the problem of duplicates..

I think you guys are right... hmm... I have my query based off my link table... I suppose I could base my cb off my the Date in my query.. but then it would should duplicates.. if I base it off my link table it is going to show the IDs... any suggestions here? I just want it to show the date...

Hello Access-Programmers.co.uk! I have a combo box on my form... I used the cb wizard to link the data from my Date Table to the cb... My form is based off a query that links Employee names with dates My Date table has the type of entry as a short date When I click on my drop box all of my...

Ok so I thought of a way to maybe clarify what I want to do... My form is created based off from my Link Query to compile all of the data for a report print out In my form I want to be able to enter first name last name. This part works fine... Then I need to recall a date for a class...

Hi, I'm not sure if I just did it wrong or not but all I want to do is make it so my save button only creates a new name not a new location, instructor... Maybe I could have my instructor and location autofill depending on the date... any idea how to do that?

Yes I understand, but I do not want to have duplicates of the instructors and locations in their tables. I want to save them in a link table. But when I hit save it saves them in their tables as well so for instance.. Last Name: Turner First name: Ryan Date: 10/18/2011 Location: Room 101...

Hello, I am designing a database to keep track of people's van driving training. I have a form to add a new member to a selected class. This is supposed to save to a query where I can then see who needs to update their training and who does not. On my form I have... Last name (text box) First...