OpenArgs in Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

has OpenArgs changed at all in Access 2003 ?

I have an application where the value of a text field on one form is used to
find the appropriate record in a table referenced by the next form. This used
to work fine but I have just noticed that after the DB was migrated to Access
2003, ths no longer seems to work.

I know that the right parameter is being passed to the form, but

DoCmd.FindRecord OpenArgs, , True, , True

no longer works.
The next form references a table whos PrimaryKey is a field whose contents
include an entry matching the entry passed to it.

Access Info from System Info is

Application name Microsoft Access
Version 11.0
Build 5614
Product ID 73931-640-4013884-57331
Application path C:\Program Files\Microsoft Office\OFFICE11\
Language English (United States)
ADO version Not Available
VBA version 6.04
References Not Available

regards
Dave
 
Hi,
i am sure at me it works in Access 2003
try put a stop at this line and check if OpenArgs has any value
 
Hi Alex,

I stuck in a MsgBox and OpenArgs has the value that was sent from the
previous form. I should have said that the new form opens but at the first
record in the table rather than that I'm trying to find,

regards
Dave
 
hi Dave,
perhaps when you starting to find - recordsource is not yet loaded. I would
suggest you to either open form filtered (you can specify where clause in
docmd.openform) or first open form, and then all it custom method to locate
a record
 
Back
Top