cmdSwitchView doesn't work in Access 02

G

Guest

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?
 

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

Repost: cmdSwitchView doesn't work in 2002 1
Form Not Populating Consistently! 0
Getting Radio Buttons to work, that are inserted via AutoText 0
select and update multiple records at the same time 1
select multiple records 2
Identity Column in SQL Server View 3
Selected subform record becomes unselected after code runs 0
Datasheet Form for Viewing Only...? 2

Top