Steve,
Do the forms freeze if you run them without having any others open? I had an error closing form 2 but ONLY if I came from form 1. It didn't occur if I opened form 2 directly. Have you tried single stepping to see what instruction they're hanging on? Finally, I'd suggest re-building...
Griff,
I'm guessing that the "Parts Used" is dependent on the "Item" selected. If that's true then your requery needs to be done when you select a new "Item" so the requery runs during the ON Click event of the "Item".
The format is "Combo-box-name.requery".
Can you not open the db at all on the other machines or does it only freeze when you click on the unbound forms?
You said you compiled on the other boxes. That suggests they have the "Full" version. Have you checked that all the references are there?
I'm asking because I just recently...
Here's two approachs I use, neither of which requires linking forms.
If form2 ALWAYS opens from form1 then form2's record source can be hard coded to select the record that matches forms![form1]![yourcriteriacontrol].
If form2 can open from many places then leave the record source alone...
The way you describe it it sounds like the combo box is not being set by the new record on the way in but IS updating the record on the way out. Once you make a selection in the combo box it's updating every record after that.
I wouldn't update the outgoing records with the combobox...
Hi Roy,
Look at these possibilities.
Is the form bound to a table? That may be where the edits are coming from. You may have to unbind the form.
Is the OnClose event for the form doing the editing? Bypass the edits if the "abort" button is clicked.
The OnClick for the "abort" button nulls...
Sorry for not getting back sooner. Thanks again for your interest in this issue. What angers me is that once we install the "Full" version on someone's box the problems disappear. I'm going to spend today re-creating one of the problem db's from scratch in XP and see if that alleviates the...
Is page8 Open? Here's some code I have used.
DoCmd.OpenForm "Add Dependents"
Forms![add dependents]!txtHiddenCategory = 3
Forms![add dependents]!cmbRelCde = "ch"
Forms![add dependents]!lblInstr.Caption = "Enter new dependent's Information
Thanks for answering but I'm sorry about the bad news. We went from Office 97 under NT 4.0 SP-2 to Office 2002 SP-2 under Windows XP Professional SP-1.
A question. Is there any way to determine, programmatically what version of a reference I'm using? I'm using MSCAL.OCX (version 10.0) but I...
We recently converted from NT to XP and my dbs are exhibiting strange behaviors in the runtime version of access. Different applications on different machines and all references have been verified.
1. Runtime version ignores default printers while "full" version machines print to correct...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.