getting error on my form on one database but not the other which is the same (1 Viewer)

[rainbows]

i have created a unbound text box called (text 12) for linking 2 forms via the stock number yet it is showing an error see below screen shot the screen shot below shows the formular
yet on another copy of that same database it works. so i am now worried that there is a problem with how i have done it but i have used this type of method to do this on other forms

is there and better method of doing this ?
thanks steve

 

[ebs17]

Stocknumber is in both tables (main and subform). Therefore, it would certainly be easier to create a link directly via these two data fields.

Properties SubForm.LinkMasterFields, SubForm.LinkChildFields

 

[rainbows]

i am not sure how to do that if they are both subforms in an empty main form ?

 

[CJ_London]

given your propensity to use meaningless names for your controls, perhaps you need to use the control name?

 

[rainbows]

i am confused. yes i know it is a meaningless name and must try and get better at this but have i not used the correct name in the field control?
=[Child68]![Form]![Stock Number]
thanks

steve

 

[Gasman]

View attachment 104273

i am confused. yes i know it is a meaningless name and must try and get better at this but have i not used the correct name in the field control?
=[Child68]![Form]![Stock Number]
thanks

steve

Who can tell?
Is child68 the name of the subform control?
Where eaxctly is that control located, which form/subform, where in the heirarchy of the forms?

 

[MajP]

I find it easier if you are linking text box Text12, to make it unbound
Then in the first forms on current Event
me.parent.Text12 = me![Stock Number]

FYI you have StockNumber and Stock Number.
Any chance you are messing that up in the linking?

 

[MajP]

FYI,
You can simply link the subforms directly as @ebs17 . I usually do the trick I showed using the first forms on current event. Because you still have to write some code to refresh the second subform.
In your case it would be

Link Master Fields: [Child68]![Stock Number]
Link Child Fields: [Stock Number]

(no ME or Parent in the linking)
However, I find I have to still put code in the first subform to refresh the second subform
In the first form's on current event you need something like
me.parent.SecondSubform.Form.Requery

This demos both methods. Using the linking textbox like you are trying and using the direct reference to the other subform which requires a requery.

 

[rainbows]

i have put the yellow lines around this form . this is where text box 12 is looking

this is where it links text12 to the stocknumber

the strange thing is it works sometimes as it does on other copies of it see below but like i said i am worried it will go wrong

 

[MajP]

Your problem seems obvious. Your linking is fine, but your control source for text12 returning an Error. Simply do what I said using the first subforms on current event to set the value of Text12 and be done with it.

 

[MajP]

Also do everyone a favor before posting again, and rename all of the relevant controls to useful information! We are guessing what is what and it wastes our time trying to decipher.

TxtLink (for your linking textbox)
subFrmPurchases
subFrmStock

When I post code people can easily determine what I am doing since my controls and variables have useful names.

 

[rainbows]

i really appreciate your help with this as i am not good at this sort of thing

i dont think i have done this correctly i did this on form child68

 

[CarlettoFed]

Perhaps it would be easier to understand if you attached the file, with a minimum of data and replacing any sensitive ones.

 

[mike60smart]

Perhaps it would be easier to understand if you attached the file, with a minimum of data and replacing any sensitive ones.

Hi

If you want to get the Stock Number from Subform1 you can use the following in your Text 12 Unbound Control:-

=[Forms]![purchasing form]![Child68].[Form]![Stock Number]

Rename this Control to txtStockNumber

Then to link Subform1 with Subform 2 use the following

LinkMaster field: txtStockNumber
Link Child field:StockNumber

 

[Pat Hartman]

Aside from the poor naming standards which everyone has already complained about, I don't see a problem.

That, and the fact that it works on one machine but not another leads me to a references issue.

The thing about reference issues which makes them so confusing is that it is the first piece of cde that errors and that is almost always not the problem.

On the machine where the code does not work ---
1. open the form in design view.
2. Open the VBA window
3. Go to Tools/References
4. Check the list for anything marked MISSING.

Possibility 2.
Maybe the file that doesn't work is corrupted. Place a new copy of the working file on the PC that isn't working.

 

[MajP]

FYI,
Everything you did originally actually looks correct assuming all the names are correct.
=[Child68].form![stock number]
Should work. I tested that construct and it worked. Maybe try deleting the text box and recreating. Your code in the current event is wrong and not needed. The suggestion was to set text12 via code, not to modify the links.

 

[MajP]

I see now. It is
.form![stock number]
Not
!form![stock number]
You show both