Form and Sub form How to use ????

[meena]

I have a form to add new records into a table. I.e for one Booking ID I could have multiple records. As I save each of my information, I need these saved records in my subform
which is by a query using my Booking ID keyed in the main form as a parameter for the retrieval. Bothe the main form and the subform are from the same table.However it does not happen. Please help.

[azhar2006]

Hello Dear meena
Attach example for see

[meena]

· I am inserting this information in Itinerary_Bookingdts table when the save button is clicked.
· As I add the other services or attractions for the same Booking id I need all the saved itinerary to appear in my below subform
· I am passing the booking id as a parameter to the query using which I have created the subform.

SELECT Itinerary_Bookingdts.BookingID, Itinerary_Bookingdts.IDate, Itinerary_Bookingdts.ServiceType, Itinerary_Bookingdts.ServiceDesc, Itinerary_Bookingdts.ServicedDetails, Itinerary_Bookingdts.AdultPrice, Itinerary_Bookingdts.ChildPrice, Itinerary_Bookingdts.NoofAdults, Itinerary_Bookingdts.NoofChild,
FROM Itinerary_Bookingdts
WHERE Itinerary_Bookingdts.BookingID=Forms![FrmdaywiseItineraryfinal]!txtbookingid
;

[azhar2006]

See this example

[meena]

Hello Azhar,

I have attached my database for your perusal. One booking ID has multiple records. As I add and save, I want the information from the table to be displayed in my subform.

[azhar2006]

take a look at how we go about doing this in practice
http://ms-access-tips.blogspot.com/2...ationship.html

You have to set up relationships between tables
Thread above shows you that
Relationship must be established
Basic keys and sub-
Where are they?

[azhar2006]

See Amendment

[ItsMe]

Add the following line
Me.Frmdaywiseitinerarydatasheet_subform.Requery

just before
MsgBox ("Record was successfully saved")

Make sure you include the underscore in the name of your subform container
Frmdaywiseitinerarydatasheet_subform

[azhar2006]

It can be converted to the organization's logo logo transparent in line with any color of the Form .

[meena]

Add the following line
Me.Frmdaywiseitinerarydatasheet_subform.Requery

just before
MsgBox ("Record was successfully saved")

Make sure you include the underscore in the name of your subform container
Frmdaywiseitinerarydatasheet_subform

Thank you so much.. Perfect!!! It worked the way I wanted it to.

[ItsMe]

Not a problem. I recommend you look into some of the suggestions of azhaar2006 by studying up on Normalization and Relational Database fundamentals.
https://www.accessforums.net/tutoria...ase-45451.html