Supply data to 'sign out' form from 'sign in' form using common element

[CarlV]

I'm a fan of names_with_underscores...hahaha....

[RuralGuy]

When you add the "." to Me. the intellisense should pop up a list of valid entries. Just select the correct one and then tab out. You are going to want to chane the (1) to the appropriate column for each entry.

[CarlV]

Excellent....
So now I have....
Me.Rank_CIV = Me.(When I let the intellisense look this part up it comes up with nothing that starts with cbo....confused again....but you are doing an excellent job at walking me through this...and you're very patient!!!)

[RuralGuy]

The actual name of each control is the 1st entry on the Other tab of the property sheet. Unless you change them, the defaults are not descriptive of the function it performs.

[RuralGuy]

Based on the code you posted it looks like your cbo is named "Ticket".

[RuralGuy]

That means you will want something like:
Me.Rank_CIV = Me.Ticket.Column(1)

[CarlV]

Private Sub Ticket__AfterUpdate()
Me.Rank_CIV = Me.Ticket_.Column(2)
Me.First_Name = Me.Ticket_.Column(3)
Me.Last_Name = Me.Ticket_.Column(4)
Me.Unit = Me.Ticket_.Column(5)
Me.DSN_Roshan = Me.Ticket_.Column(6)
Me.Service_Tag_Serial_Number = Me.Ticket_.Column(7)
Me.Make_Model = Me.Ticket_.Column(8)
End Sub

With the above I get no error messages when I select a Ticket # from the drop down, however I also get no data into the fields.

[RuralGuy]

You named your cbo control "Ticket_"? Are you letting the intellisense find your cbo name and then hitting the tab key?

[CarlV]

Yes...When I look at the property sheet for the cbo the Name is "Ticket#". When I let intellisense lookup the name for the second half with Me. it gives "Ticket__" as the option. (Two underscores).

[CarlV]

It looks as if the expression is built correctly, however when it executes no data is pulled from the actual cbo and inserted into the fields on the sign_out form. Is there another function that must be written in to set the focus on each of those fields and insert that data that was retrieved?

[RuralGuy]

You do not need to change the focus. How about changing the cbo name to cboTicket and try it. You will need to rename the AfterUpdate event procedure.

[CarlV]

Okay, I renamed the combobox to cboTicket.
When I did Me. it pulled up cboTicket
example: Me.Rank_CIV = Me.cboTicket.Column(2)
I made sure the name of the EvenProcedure is now
Private Sub cboTicket_AfterUpdate()

I still get no errors when I select a Ticket # from the list, however I also still get no data in the corresponding fields.

[RuralGuy]

Add a MsgBox Me.cboTicket.Column(2) to the code and see what the computer sees.

[CarlV]

I input MsgBox Me.cboTicket.Column(2) and got no results. No popup box, nothing.

[RuralGuy]

Have you set your Trusted Location yet? http://www.btabdevelopment.com/ts/de...aspx?PageId=13