If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subform master child link
Hi,
I have the following problem. I have a form A with a subform B. On form A I have to comboboxes c and d. On my subfrom I have two textboxes e en f. I'am trying the following. Creating a sellecion on the subform based on the values of c and d. Source object: B Link Child Field:c;d Link Master Fields: e;f This gives me an error of not finding e and f. If I change Link Master Field to :c;d it returns results but only based on c; What am I doing wrong?? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/201003/1 |
#2
|
|||
|
|||
Subform master child link
On Sun, 28 Mar 2010 20:20:54 GMT, "janiotjoeawie via AccessMonster.com"
u7669@uwe wrote: Hi, I have the following problem. I have a form A with a subform B. On form A I have to comboboxes c and d. On my subfrom I have two textboxes e en f. I'am trying the following. Creating a sellecion on the subform based on the values of c and d. Source object: B Link Child Field:c;d Link Master Fields: e;f This gives me an error of not finding e and f. If I change Link Master Field to :c;d it returns results but only based on c; What am I doing wrong?? Sounds like you have it backward. The main form is the "master" and the subform is the "child". The Master Link Field can be either the name (or names) of a field in the form's Recordsource, or the name of a control (textbox, combo...) on the mainform. The Child Link Field must be the name(s) of a field (or fields) in the Subform's recordsource. It can't be a control. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Subform master child link
Thanks a lot,
I did had it backward. Geuss that is is not good looking at the same ting for more than 3 hours John W. Vinson wrote: Hi, [quoted text clipped - 10 lines] What am I doing wrong?? Sounds like you have it backward. The main form is the "master" and the subform is the "child". The Master Link Field can be either the name (or names) of a field in the form's Recordsource, or the name of a control (textbox, combo...) on the mainform. The Child Link Field must be the name(s) of a field (or fields) in the Subform's recordsource. It can't be a control. -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|