Search results

Not quite understanding your issue. If form C is picked you want an autonumber filled in Contract, say #523 Form A is picked, user manualy types a number, say #524 Form C is picked, you want a autonumber to fill #525? Does this autonumber only increment when Form C is picked? Do you have a...

If the Entitlement field is not linked to a table and is just used on a form for the user: If "TextFormula" control source is =Round([Position1]/[Stk Ratio 2]*[Stk Ratio 1],2) Create another text box "TextShow" with it's control source as =iif(iserror([TextFormula]),"TBC",[TextFormula]) Now...

You shouldn't use () when naming forms, queries, controls, etc. It gets confusing in VB. add [] to get around this: [Forms]![frmDept(Search)].Requery I don't know why you have this code after but I REMED in out: ' Screen.PreviousControl.SetFocus ' DoCmd.FindNext

Check your code behide the "save" button

Yes, please post......

Yes, please post.... In the design view of the query right click in a blank area, and go to properties.

On the properties of the query: "Recordset Type" should be set to "Dynaset" not "snapshot"

It sounds like you have it setup OK. Run the "qryTest". Are you able to add a new record to this query?

There's your problem, you are trying to go to a new record in a query that will not allow you to create a new record. Back to what I said earilier in this thread, Create a new query that is looking at the table in reference that is not linked to your mainform. This new form will only be used...

Yes, this might be the problem if your recordset is locked. Try this, with your continuous form open, run the query that is the recordsource for your new form. Are there records shown? Can you add a new record in the query?

What is the recordsorce for this new form? A table, or a query? If it is the table that your continous form is using, and you are still having problems, you might have to create a new query with 4 fields and use this as the recordsouce for your pop-up form. It should not be a subform, rather a...

Here's one way of doing it...... Create a new form with the table you are referencing to as the recordsource and add the 4 controls to the form. Set the forms properties: Modal - yes Pop-up - yes On the OnLoad event of this form, write code: DoCmd.GoToRecord , , acNewRec Put two buttons on...

I have never had this problem with any of my forms..... then again, I never let access create my forms for me, I create them from scratch and give them names that I can easily identify.....

I'm sorry, if you want to trigger the requery from a checkbox, you should use the OnClick event. I'm not sure what the other guy in this thread is referring to, but I've used this to requery forms in everyone I've created with no problems: Go to the properties of your checkbox. Click the "..."...

David, I would add this code to the after update event of your sold check box. It's hard to say without being able to work with your form and understanding the flow. I would add it to the after update event of the last required step when adding a inventory item. As far as the other total, If...

Hello David, Build a query, showing the table of your inventory items. Bring in OrderID and ItemCost. In the ItemCost field, select SUM in the totals. In the criteria area for OrderID, reference the OrderID feild on your main form like this: [forms]![MainForm]![OrderID] Now build a new form with...

I think this is what your tring to do..... If it was, you were making it way more complicated than it had to be. See your attached updated DB..... Do you understand this?

This is what I do. It's probably not the best way, but it helps me debug if issues arise. Create a subform on your Mainform that is using the other table as it's recordsource. Link this form to your main form and hide it. Now you can write code in the afterupdate event of your control. - if...

Try creating a query that is based on your table that orders by order date. If this works, make this query the recordset for your subform.

Got it...... Thanks for the help..... I really could not figure out your solution. I figured out a way of doing it that works fine for me. Probably not the best way but: I put an unlinked subform on my main page that is based on a query where the criteria looks at my batch and lot #'s on my...