Solved: Opening a table at a specific record

[fif_rumac]

Hello All,

I have a problem which I hope you could help me with...

I have a button on a tabular form called "Pipeline" which opens up another form at a specific record. the code is as follows:

DoCmd.OpenForm "Proposals", , , "[ID]=" & Me![Proposal ID]

The problem is that i'd like to be able to use the same principle to open up a table rather than a form...

i.e. a button on every record of a tabular form which opens up the proposals table at that specific record...

Thanks,

fif_rumac

[geekgirlau]

Actually, you are better off creating a tabular form for the proposals -NEVER give ordinary users direct access to a table unless you enjoy major headaches!

[fif_rumac]

This function would not be for ordinary users though.

[OBP]

fif_rumac, I have to agree with geekgirlau, but you obviously have a need to do this. Can you explain what advantage you see in working directly in the table rather than in a form or query?
I have looked at the standard "docmnd" method of openeing a table and it doesn't have any filter options, which means that you would have to try and apply the filter after had been opened.