Form Contol value to equal another

  • Thread starter Thread starter Ladybird
  • Start date Start date
L

Ladybird

Need the autonumber PK to be entered in another (Form & a Subform) tables FK
field on a form, I have tried in the Control Source
[myFKfrmControl]=[myPKfrmControl] gives #Name? & Default Value
=[myPKfrmControl] with no success. Such a fundamentally simple thing yet
arrrgghh!
 
Ladybird said:
Need the autonumber PK to be entered in another (Form & a Subform)
tables FK field on a form, I have tried in the Control Source
[myFKfrmControl]=[myPKfrmControl] gives #Name? & Default Value
=[myPKfrmControl] with no success. Such a fundamentally simple thing
yet arrrgghh!
Click to expand...

If the second form is within a subform embedded within the first then you use
the MasterLink ChildLink properties of the subform control to do this.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default value of combo box based on another combo box 6
Form design to add data to 3 tables in "Order Entry" style db 1
Design of a simple sales entry database form 1
help required in designing an inventory form 6
Order form 2
Dlookup to compare two values? 0
Using an unbound combobox to filter another combobox 1
Passing forms values to a report 1

Back
Top