Search results

Im pretty sure the field is an AutoNumber (thats what it is set at in the table) Ill test it out once I get home.

Thanks for the warm welcome guys, much obliged! :) Im sure I will be able to learn a lot from you guys!

The Booking Nr is of numeric value. In that expression above we are basically saying 1. open report confirmation 2. in preview mode 3. The value of Booking Nr is found in the "switch_all_bookings" subform. If my understanding is correct then it should work... its gettin kinda late...thanks...

im not going to lie...I dont really understand that site. :banghead: lol - The main form is called Switchboard - the subform is on the Switchboard and its called switch_all_bookings. This form is based on a query....does that maybe have any influence? No Criteria is set...I just needed info...

The field name was correct. The control name would be the name of the subform I am trying to extract the Booking number from, correct?

Yes the long names of the forms etc are starting to annoy me lol Right ok I just tried that code but I receive an run-time error 2465 "Cant find the field "|" referred in your expression" Does the subform maybe need to be configured in a particular way??

im not sure this is what I need. I read through it but it will only filter the data and not put it into a report, correct? Theres second page which seems more suitable with the following code: Dim rs As Object Dim lngBookmark As Long 'set a variable to the current record lngBookmark =...

Greetings! I have just joined (look for my Intro post ) after looking through the forum looking for a solution for my problem in my database...I didnt see anything that applied to my situation. Now the fundamental point of my Database is to take bookings, calculate the costs and print out the...

Hello all! My name is Navi, Im 27, and I'm a British Indian living in Germany. I enjoy watching Films, playing video games (when I have the time :banghead: haha) and I do like a nice rave now and then :D I first dabbled with Access way back in 2001 back in School and used it somewhat regularly...