Recent content by pvrwizard

Thanks for the guidance I knew it had to be something simple I forgot to do

Yea I had an idea that might cause an issue.. easy enough to change along with the time field.

so yea figured it our literally 10 seconds after i uploaded.. i changed the name of the form a while back from the default the wizard gave it and never actually went in to the properties and changed it to match.. sigh.. working perfectly now.

okay here is the database not very pretty yet but that will come later

uploading a copy of the data base it has 2 test customers in it. one has 1 tour scheduled the other has 2 tours scheduled.

okay actual form names FCustomers - main form FTourSummary - datasheet i want to click to display full data in FTourDetail I create an invisible text box on the main form and left the default name to test so it was named Text30 i set the controlsource as =FToursummary.Form!Date on...

well didn't work tells me it's not in the list and won't go any furthur.

Jesus if that works i'll feel dumb figured if it wasn't in the drop down it didn't see it as a control you could link to.....

macro errors when i use this approach Forms!FCustomers!FToursummary.Form.RecordSource = "SELECT...WHERE TourID = " & Me.TourID can't find macro Forms!FCustomers!FToursummary

I saw this as a solution on another place.. the invisible text box didn't appear in the drop down list on the link master field.

I would have thought this would be pretty simple but either I am missing something really simple or I just haven't found the answer yet. I've seen a couple different solutions for something similiar I am trying to do but nothing that was really exact. I have 2 tables Customers and Tours 1...