Show all data off a combobox on a subform

M

mtagliaferri

Registered User.
Local time
Today, 15:42
Joined
Jul 16, 2006
Messages
550
I have a subform for a hotel list, I have a combobox on the subform that show the list of the hotels, what I need is to create some fields on the subform wich shows me all the details of the hotel as address, email, facilities once I have selected a hotel from the combo list.
How can I achieve this!
Thanks
Marco
 
Have a look at the attached sample, is this how you want the subform to work?

Have a look in the tables and see how the data is stored.
 

Attachments

Hi John A, That is what I am aiming at, thanks very much for your help, I will be able to solve my problem.
Marco
 
John, I have inserted the sfrmSub into a TAB CONTROL, doing this I loose the function of the subform, How come this?
Marco
 
mtagliaferri said:
John, I have inserted the sfrmSub into a TAB CONTROL, doing this I loose the function of the subform, How come this?
Marco
Click to expand...

Have a look at the sample.

I would say that you have added the subform and it can't find the main form, so when you try and add a record to the subform it won't save the record because it can't find the related record in the main form.
 

Attachments

Hi John, thaks for the quick reply, I am still having problems!!! What I am doing is fraghing the sfrmSub into the TAB CONTROL, what I obtain is a blank rectagular with no subform, once I run the form normally I will see the subform but this will show all the records off the subform and not the one related.
Am I so thick that cannot understgand to procedure to do it :(
 
The One You have sent me it works, but if I drag the sfrmSub on the spare TAB it doesn't work.
What is the master child link?
 
If you don't know about "Child" and "Master" , then may I suggest that you do bit Of "Searching" in the forums and on Google and reading of the Help section in Access.

They are used to link the Main Form and the Subform (In a 1 - Many relationaship "Each Record in a subform must have a related record in the main form")
 

Attachments

You must log in or register to reply here.

Similar threads

O
Solved Unbound Form, Two Subforms: Checkbox Selection for Product-Hotel Association
Replies
7
Views
961
Odeh Naber
O
T
Solved Continuous Sub-Form
Replies
17
Views
1,277
mike60smart
mike60smart
G
Combox uses 'wrong' value list
2
Replies
33
Views
833
June7
June7
S
Solved Need help querying subform's combo box based on the main form.
Replies
13
Views
837
SkeletorPlus
S
F
Open multiple instances of subform
Replies
7
Views
482
MajP
MajP

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom