Subform LinkMasterFields Problem.

[lindsey]

Hi, when i try to enter values into my subform, i am hit with this error:

"The LinkMasterFields property setting has produced this error: "Member
already exists in an object module from which this object module derives.""

What does this mean?

I couldn't find a solution for this anywhere.

After i hit the "OK" button, i still can go about doing entry as per normal.
But is there anyway to get rid of that prompt button at all?

You can see a screenshot at
www.blog.mybrownslippers.com/content/access_woes.JPG

Many thanks.

 

[Ken Snell \(MVP\)]

What values do you have for the LinkMasterFields and LinkChildFields
properties for that subform? Do you have another control on the subform that
is bound to the Receipt ID field? I think you should move the Receipt ID
textbox to the form header section of the subform's form object and make the
textbox invisible.

 

[lindsey]

hi ken, thanks for your reply.

i managed to solve the problem by redoing the subform compilation and by
using the dlookup function.

i just have another question left.

upon typing in the item_ID in the receipt subform and tabbing out, the
database supposed to retrieve the item_saleprice from items table. (i enable
it by using the dlookup function.)

however, the item_saleprice is not retrieved and shown immediately in the
next field upon the tab out of item_ID. instead, i need to close the form and
open it up, before the item_saleprice finally shows up in where is supposed
to be.

is there anyway to force the item_saleprice to show, immediately upon
tabbing out of the item_ID?

thanks again.

 

[Ken Snell \(MVP\)]

I don't have sufficient information about your subform's design and setup to
give you a specific suggestion here.

However, a typical way of doing what you seek is to use a combo box so that
the user can select an item_ID, and to have that combo box's RowSource query
contain the price for each item_ID and to then let the selection cause the
price to fill into a textbox. See this web page article for a way to do
this:
http://www.mvps.org/access/forms/frm0058.htm:

Otherwise, the problem may be in how you've structured the DLookup function
and what it's using for the filtering criterion. Are you using the control
on the form as the source of the filtering expression's value? If yes, you
can use the AfterUpdate event of the item_ID textbox to run code that does
the DLookup and writes the sale price into a textbox.

But you'll need to give us more specifics about the subform's design, its
RecordSource, what controls are on the form and to which fields they're
bound, etc. if we are to provide more specific suggestions.