One form for Many Tables

[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?

 

[Jeff Boyce]

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

 

[brownti via AccessMonster.com]

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

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

[quoted text clipped - 4 lines]

have tried several things with VBA and cant figure out the coding. Anyone
have any suggestions?

 

[Jeff Boyce]

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:


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

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

[quoted text clipped - 4 lines]

have tried several things with VBA and cant figure out the coding.
Anyone
have any suggestions?

 

[brownti via AccessMonster.com]

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...

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:

[quoted text clipped - 24 lines]