Combobox data from form not showing on report

nomax

Registered User.
Local time
Today, 15:16
Joined
Dec 20, 2015
Messages
21
So stuck on this. Relative newbie and will try to explain this as best as I can.

FORM 1 - Group Master Information
FORM 2 - Individual Reservation under the Group

On FORM 2 I have used a combobox to populate a group of fields from FORM 1 so that the information doesn't need to be entered manually each time you add a reservation to the GROUP. This works fine, no problems with it.

My problem is when I open the report for the individual reservation the fields that are populated by my combobox are blank. I cannot figure out how to get this information to appear on the report.

I have added screen shots of GROUP FORM, FORM 1 and REPORT - The items in purple are the fields that I am trying to show on the report from FORM 1
 

Attachments

  • GROUP MASTER.JPG
    GROUP MASTER.JPG
    26.4 KB · Views: 91
  • FORM 1.JPG
    FORM 1.JPG
    35.8 KB · Views: 95
  • REPORT.JPG
    REPORT.JPG
    18.4 KB · Views: 93
For your benefit, and to help others offering you assistance, it would be helpful to identify WHAT your database is about in general terms and work to add more detail as needed.
What tables and relationships do you have? Can you post a copy of your database? --remove anything confidential/private; then post a copy as a zip file
 
Thank you, I am a travel agent, the database is a CRM with both cruise, tours, FIT booking information as well. Customer profiles etc. As I am using the database, to post a copy of it would be an incredible amount of work to strip it down to remove all the personal information already contained in it. Any suggestions?
 
Is this a purchased software package or something you have developed/had developed?

Readers don't want your customer list etc. Just thinking while typing --
you could make a copy of the database; delete most records;
change the names to Porky Pig, Daffy Duck, sort of thing to remove any specificity to real clients.
We only need enough data to show the issue. So, it seems a Group --could be Group1, consisting of individuals "Sheeza Payne", "Ima Redneck"... on cruise "The Albatross", "Sea Witch"...

However, before doing anything Make a Backup of your database. Never develop on an operational/production database.
 
Not purchased I developed it. Maybe I could just Copy those forms to a new database and upload that, let me try if that will work. I'm not worried about someone stealing my customer list, it's a little sloppy right now with many revisions, changes, forms that I am not going to use and am deleting.
 
Okay, stripped down version (removed sub forms from the forms as they don't really have anything to do with the issue I'm having. The way it works

Open GROUP MASTER - add all of the information from GROUP MASTER open ADD INDIVIDUAL TO GROUP. By choosing the Master Booking Number - fields on this form are populated with the information from the GROUP MASTER. Complete the rest of the forms - open REPORT - everything moves fine from INDIVIDUAL BOOKING to the report, except for the fields that are pre-populated from the GROUP MASTER. Except now that I stripped these forms out from my database it worked. Somethings hinky - please disregard this post until I figure this out.
 

Users who are viewing this thread

Back
Top Bottom