One form for Many Tables

  • Thread starter Thread starter brownti via AccessMonster.com
  • Start date Start date
B

brownti via AccessMonster.com

I have 4 tables that have all different information except for one thing
(Notes). The notes on these tables are entered form a popup form from a main
form. I would like to only create one form whose recordsource and the
control source of the "Notes" control changes based on the button clicked. i
have tried several things with VBA and cant figure out the coding. Anyone
have any suggestions?
 
If you'll describe what you've already tried, folks won't be tempted to tell
you to try something you've already tried...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I havent really tried anything that makes sense. I tried:


stDocName = "frmNotes"

stLinkCriteria = "[MouldingID]=" & Me![MouldingID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Me.RecordSource = "tblMouldings"
Me!MouldingNotes.ControlSource = "MouldingNotes"

But that doesnt work...

I need to change [MouldingID], tblMouldings, MouldingNotes

Jeff said:
If you'll describe what you've already tried, folks won't be tempted to tell
you to try something you've already tried...

Regards

Jeff Boyce
Microsoft Office/Access MVP
I have 4 tables that have all different information except for one thing
(Notes). The notes on these tables are entered form a popup form from a
Click to expand...
[quoted text clipped - 4 lines]
have tried several things with VBA and cant figure out the coding. Anyone
have any suggestions?
Click to expand...
Click to expand...
 
We aren't there, and can't see your Access database.

"that doesn't work" doesn't give us much to go on ...

Does Access quit without warning when you try that? Does it turn off your
computer? Does it give results (but incorrect results)?

And I'm not entirely clear what you are trying to do...

Are you saying you want to keep notes in a single table, instead of having a
Notes field in each table?

Regards

Jeff Boyce
Microsoft Office/Access MVP

brownti via AccessMonster.com said:
I havent really tried anything that makes sense. I tried:


stDocName = "frmNotes"

stLinkCriteria = "[MouldingID]=" & Me![MouldingID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Me.RecordSource = "tblMouldings"
Me!MouldingNotes.ControlSource = "MouldingNotes"

But that doesnt work...

I need to change [MouldingID], tblMouldings, MouldingNotes

Jeff said:
If you'll describe what you've already tried, folks won't be tempted to
tell
you to try something you've already tried...

Regards

Jeff Boyce
Microsoft Office/Access MVP
I have 4 tables that have all different information except for one thing
(Notes). The notes on these tables are entered form a popup form from a
Click to expand...
[quoted text clipped - 4 lines]
have tried several things with VBA and cant figure out the coding.
Anyone
have any suggestions?
Click to expand...
Click to expand...
Click to expand...
 
Sorry for not being clear. I wasnt totally sure of what i wanted to do...i
know now and have figured out what i want to do...

Jeff said:
We aren't there, and can't see your Access database.

"that doesn't work" doesn't give us much to go on ...

Does Access quit without warning when you try that? Does it turn off your
computer? Does it give results (but incorrect results)?

And I'm not entirely clear what you are trying to do...

Are you saying you want to keep notes in a single table, instead of having a
Notes field in each table?

Regards

Jeff Boyce
Microsoft Office/Access MVP
I havent really tried anything that makes sense. I tried:
Click to expand...
[quoted text clipped - 24 lines]
Click to expand...
 
Back
Top