Pre populate a second form

[sliminconcoova]

Hi guys, sorry if this question has been asked before but I can not find an answer I can understand so please bare with me as I am quite the rookie at things like this.

I have form one (Customers) and it has a subform Servers which I dont want the user to edit directly. So to get round this I want a button to open the (Servers) form in add mode. I know how to do that, what I want though is the Customer drop down list to be populated with the customer being viewed in the first form.

My research revealed I need to possibly carry over the information, I have no idea how to do this? Hope you can help.

[pkstormy]

To move to the appropriate 'Customer' on the Main form when a combobox value is selected on the subform...

You could make sure the CustomerID or whatever field uniquely identifies the customer in the main table is a column in the dropdown box on the subform (I'm assuming this combobox is on the subform), and then in the afterupdate event, you could put code in as such:

Assuming you have a 'CustomerID' field in the main table
dim CustID as variant
CustID = me.MySubformComboboxField.column(X)
'where X is the appropriate column that has the CustomerID value
Forms!MyMainCustomerForm.setfocus
Forms!MyMainCustomerForm!CustomerID.setfocus
'assuming that the CustomerID field on the main form is enabled and visible.
docmd.findrecord CustID
'Now requery the subform...
Forms!MyMainCustomerForm!MyServerSubformName.reque ry

[pkstormy]

I think I misunderstood your question. After re-reading my response, I don't think I answered your question. Could you explain a little more?

[sliminconcoova]

no that does answer my question thanks pk! it puts me in the right direction at least. Its the coding bit i struggle with and that helps a lot! two smileys for you lol