Search results

If there are child records, how would I undo those? I have tried opening the form without the AcFormAdd and it still added the record.

I call my NewOrderF with an acFormAdd to add a new order. This form has a subform NewOrderDetailsSubF. When I open the NewOrderF form, it creates a record on the OrderHeaderT and even if I close the form without adding any items in the subform, the record remains. I have tried putting an...

Here's the database - please note that it's in a state of flux. The route to where I want this to apply is Main Menu - Customers (choose DEB) - Orders - Order Details. (Use Customer PO. Number TEST2001 as the best example)

This is more of a logic question than a programming question (potentially). Status of an order and an order line can be: 1. Active 2. Part-shipped 3. Shipped 4. Invoiced 5, Paid These are in a StatusT with a description of the status and just the StatusID is attached to the OrderHeaderT record...

Pat, because there isn't the facility to scroll to a new record. This works as a one off form - to get a new record, the click on a 'Add New' button which reloads the form from scratch.

Thank you. Using Variant worked exactly as I desired. Thanks for all your help.

So, when I go to the form from the Main Menu, I have a combo-box which allows the Customer to be selected. When I go to the form from the OrdersF form, I have already selected the customer and I want the current Customer details to be displayed as the default in the combo-box.

I do the test in the NewOrderF but the point is that I WANT the OpenArg to be empty - it's to enter a new order for which I haven't chosen the ID yet. I only want the OpenArg to have a value if I have a CustomerID to pass to it.

OK, so I'm playing with OpenArgs now. Here is my code when opening from OrdersF and passing the CustomerID Private Sub NewOrder_Click() Dim CustomerInputID As String CustomerInputID = Me.CustomerID DoCmd.OpenForm "NewOrderF", , , , acFormAdd, , CustomerInputID End Sub The...

OK. OpenArgs is a whole new ball game for me - I'll look it up on Sunday. Thanks

Typically, when I went back to it this afternoon (having not made any changes from it from last night), it had stopped working again. I'll take another look on Sunday when I'm not as frazzled.

Thank you all for your help! As I said in my previous post, please remind me NEVER to offer to help family and friends just because 'you know computing - you can do this!!"

Yes! That's how you do it! DoCmd.OpenForm "NewOrderF", , , , acFormAdd Forms!NewOrderF!CustomerCombo = Me.CustomerID I didn't realise that the code that comes after the OpenForm command relates to the newly opened form. In general programming, the command to do something would then do that...

Yes but I have to manually drop down the ComboBox. I'm just wondering, should it be the CustomerCombo.DefaultValue that is set to Me.CustomerID?

It's the Forms!OrdersF!CustomerID line

Sorry pbaldy, I'm not normally this thick! I added the extra line and now get the following error. I think I need to get something to eat (and maybe a VERY large glass of something alcoholic!

I've tried that as follows: DoCmd.OpenForm "NewOrderF", , , , acFormAdd Forms!OrdersF!CustomerID.DefaultValue = Me.CustomerID This doesn't put the CustomerID in the ComboBox and bring up the Customer Name and Code.

Add the second line of code where - in the call to the form? Won't the Do.Cmd just open the form before populating the field? Potentially, when the NewOrderF is open, the user can add further orders.

No, I don't think I get this. So from the MainMenuF, I just use the straight NewOrderF (which now has no default) i.e. DoCmd.OpenForm "NewOrderF", , , , acFormAdd as before But how would it work from the OrdersF form which now needs to pass the CustomerID as the default for the ComboBox on the...