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

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]

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