autopopulate fields on FormB with data from FormA

[CBG2112]

I would like to autopopulate and display data on some fields of FormB when the user presses btnAddRec on Form A. The data will be coming from FormA. I have added code below on the OnLoad event of FormB but it does not work. I only want these fields to be autopopulated when it's a new record. Thanks.

Private Sub Form_Load()

txtRelatedTo.SetFocus
If IsNull([txtRelatedTo]) Then
    Me![txtRelatedTo] = Forms![frmTaskDetail]![TaskID]
End If
cboSTPriorityNum.SetFocus
if IsNull([cboSTPriorityNUm]) Then
    Me![cboSTPriorityNum] = Forms![frmTaskDetail]![Text6]
End Sub

.

 

[pbaldy]

You can test with:

If Me.NewRecord Then

 

[blue-bullet]

I can only find this being mostly related to my question and not sure if this is solved?

I have Form1 which is a customers form which has a subform with a list of devices (populated from the devices table)

My question is, from my customers form, I want to be able to create a new entry for the devices table. - i also want the customer id to already be selected in the device form. any chance for an example code?

 

[pbaldy]

You shouldn't need code. If the master/child link properties of the subform control are set to that field, it will populate automatically.

 

[blue-bullet]

ok i think ive confused you. Basically, on the customers form, if i double click the device in the subform, I can go to that device in the device form.

I want an extra button that opens and creates a new entry in the devices table pre populated with the customer id. Sample code anyone?

 

[pbaldy]

DoCmd.OpenForm "SecondFormName"...
Forms!SecondFormName.CustomerID = Me.CustomerID

 

[blue-bullet]

DoCmd.OpenForm "SecondFormName"...
Forms!SecondFormName.CustomerID = Me.CustomerID

thanks, but when i run that, it errors, the debug shows the yellow highlight on the second line.

When I mouse over it, it tells me the query responds with the correct ID (29) which relates to the double clicked record, so why will it error?

 

[pbaldy]

Are all the form and control names correct? If so, you might need to add

DoEvents

between those two lines to give the form time to open.

 

[blue-bullet]

nope that didnt do it

 

[pbaldy]

Can you post the db?

 

[blue-bullet]

Can you post the db?

here you go, to see the issue, open the customers form, then in the subform doubleclick the device (testserver1) and thats the error.

I want it to go to that record when i double click it.

 

[pbaldy]

I get an "unrecognized database format.." error on that with 2007. Can you try again, or convert a copy to a lower version?

I love that quote. I'm going to use it on a buddy who's IT Director at the university. It seems like all he does is have meetings all day long.

 

[blue-bullet]

I get an "unrecognized database format.." error on that with 2007. Can you try again, or convert a copy to a lower version?

Yea sure, here it is matey

I love that quote. I'm going to use it on a buddy who's IT Director at the university. It seems like all he does is have meetings all day long.

It was like that in my previous job, we spent more time in meetings than doing the damn work! We kept getting "we will have to organise a meeting as its not within the scope of this one"...bloody project managers! << (Sorry if that offends anyone lol)

 

[pbaldy]

For starters you have the forms reversed, it's

Target = Source

Secondly, you are referring to device ID instead of customer ID. Device ID is an autonumber so you can't set it anyway. Thirdly you weren't opening the form in add mode. See if this does what you want:

DoCmd.OpenForm "Devices", , , , acFormAdd
Forms!Devices.CustomerID = Me.CustomerID

 

[blue-bullet]

For starters you have the forms reversed, it's

Target = Source

Secondly, you are referring to device ID instead of customer ID. Device ID is an autonumber so you can't set it anyway. Thirdly you weren't opening the form in add mode. See if this does what you want:

DoCmd.OpenForm "Devices", , , , acFormAdd
Forms!Devices.CustomerID = Me.CustomerID

I ahve it so when adding a new device the customer id is in there. not a problem.

What I want now is the double_click feature to go to the record i double clicked...

 

[pbaldy]

This kind of thing?

http://www.baldyweb.com/wherecondition.htm

 

[blue-bullet]

This kind of thing?

http://www.baldyweb.com/wherecondition.htm

BINGO WAS HIS FRICKEN' NAME OH!

Thanks Baldy, your a saint - what a nice ending to my english day! enjoy the rest of yours

 

[pbaldy]

Happy to help. Now head for a pub!!