Search results

I need to keep the form as it is rn as that is how it was requested, because it should be about the order/load not about customer. I will have a query/Form that will show orders by customer that will be Customer form with orders subform in datasheetview. I am using code below now to open the...

I had this problem, didn't know at the time that need to delete fields from the Record Source of the form as well )

The syntax you provided works exactly as you advised: other form needs to be opened and the focus remains on the Customer form. The Order form(frmMainOrders) works with no problem. I type the customer name in Customer field and it filters it as I type, thanks to help from members of this...

Maybe something like this:

The frmMainOrders opens but nothing the value won't transfer, just a blank form.

Any ideas why my the current code doesn't work?: Private Sub InserttoMainOrder_Click() DoCmd.OpenForm "frmMainOrders", , , "CustomerID = " & Me.CustomerID End Sub

Pickup and Drop locations are 2 different geographical locations. Driver goes to the Pick location takes the load delivers to the Drop location. Yes, EmployeeID is the person that who took the order. Drivers are mainly contractors, but I was thinking of merging this 2 tables.

That is exactly what I want, value of one field to transfer to another, I need to get the terms right. )

And the subject of this thread should read: "Inserting currentRecord from open form to another form.

Any suggestion regarding the relationships? :rolleyes:

What if I need to add just a new customer without creating an order for him?

I am not sure if you checked the screenshot of the Order form I attached. Are you suggesting adding customer subform to the order form?

I am, I have a subform on my main form and few others.

Here you go :

I have an Order table with FK CustomerID from Cusotmers table and some other fields. I've created a form based on the Order table. On the Order Form i just need the CustomerID (which is a combobox with select query), that is all the info I need about the customer on that form.

What I meant is that, I have a customer form and let say I just entered new customer details or selected existing one and want to create new order for him. As I am on this form, instead of closing this form and going to the main form to create new order for him, I just click a button on the...

I have a customer form where I need a button that should copy/insert the CustomerID value to CustomerID field on the main form. The CustomerID on the main form is a combobox with a query that selects values from the customer table. I tried this code and it opens the main form with CustomerID...

This is the code I originally used and it works fine. Only problem is that I could not use arrow keys to select from the filleted list. The solution by MajP is the one I am using right now for that reason.

Thank you for the help, it works great. Learning a lot from this thread :)

when I use this code: Private Sub Form_Load() faytProducts.InitalizeFilterCombo Me.PickLocation, "FullAddress", AnywhereInString, True, False faytProducts.InitalizeFilterCombo Me.DeliveryLocation, "FullAddress", AnywhereInString, True, False End Sub it only works for DeliveryLocation. Could...