OPENFORM macro

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Dear all,

I have a form (SALES) based on a query which includes some calculating
fields, like sum, count. There's an unbound combo box for all cities.
When I change the value in the combo box, the text boxes based on
those calculating fieds change accordingly.

Then I made a switchbord and made a button using OPENFORM macro to
open the sales form. When I open it, the combo box no longer works.
But if I just double click the SALes form in the database, it works
fine. I don;t understand. Could anyone kindly help me to figure it
out? THanks a lot.

Jim
 
Check the arguments you used in the OpenForm Macro,
especially the 'Data Mode' argument. You might have used
a wrong value for this argument.

HTH
Van T. Dinh
MVP (Access)
 
Thank you, Van. I set the "data mode" as read only, now I changed to
Edit. It works. Gracias!!!
 
Back
Top