Repost: cmdSwitchView doesn't work in 2002

S

SLZ

My database has a search module that can retrieve multiple
records based on specified criteria. If multiple records
are retrieved, they are displayed in a subform in
datasheet view. User can then click cmdSwitchView to view
additional info in form view of a selected record then
toggle back to datasheet view to see more records. Command
has worked beautifully for 4 years in Access 97; won't
work in Access 2002 conversion. When user selects a
record in datasheet view, all records disappear.
Code =
DoCmd.Maximize
Me![frmSearchSubformNew].SetFocus
DoCmd.DoMenuItem A_FORMBAR, 2, 3

Tried doing without cmd by just setting Default View to
datasheet; records still disappear when click View button
to select Form view. Many thanks in advance if you have a
solution?

..
 
D

david epsom dot com dot au

Resetting the sub-form Filter or RecordSource?

Sub-form filter is too flaky now: you probably
have to modify the RecordSource.

After changing recordsource, you may have to reset
master/child link fields.

(david)
 

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

Top