Subform

Azhar.iq

Registered User.
Local time
Today, 13:56
Joined
Apr 10, 2015
Messages
18
Hello everyone,

I have an access form that displays some data about customers and their booking for flight. so lets say if there is a group of five people that made a booking for a certain flight, i have to assign ticket numbers to them and store it in some table.

Now i can display the number of people in a group for a certain flight in a subform, i want to have another textbox in front of their names so i can type in the ticket numbers. So i went to design view and added another textbox, but the problem is if the subform in displaying 5 rows (for 5 customers) when i type in a ticket number for one customer, all the following rows gets and displays the same ticket number. How can i type something and let it not be repeated infollowing rows.
 
your ticket number needs to be a field in your table. No idea what your table structure is, but I would guess you have an 'event table' where the fight details are stored and a customer table with the passenger details
 

Users who are viewing this thread

Back
Top Bottom