Form help

[GinaWhipp]

You want your Users to enter data via a Combo Box but all the data is from separate fields. AND, you don't want it BOUND to the table, well, probably can't be because all the data is from separate fields. Not even going to go to the other items you requested. I have never done it this as it's more work than it's worth but I imagine it can be done. Why don't you just store that value in one field?

 

[jober]

Sorry worded that wrong, the combo box uses a table to get its info from and it will auto fill on a Continuous subform, then evertime the user selects a new procedure it will requeary and add another procedure to the subform. Is this do able?

 

[GinaWhipp]

Yes, that is doable... and thank goodness because the other way would have been much more difficult.

 

[jober]

Ok i got that to work. To auto fill my form but now i have to figure out how to go to the next item on the subform. Here is the code that i have....
Private Sub cbopro_AfterUpdate()
Me.subform1!Procedure = Me.[cbopro].Column(1)
Me.subform1!REV = Me.[cbopro].Column(2)
Me.subform1!TA = Me.[cbopro].Column(3)
Me.subform1!REV1 = Me.[cbopro].Column(4)
Me.cbopro.Requery
End Sub

When it fills the first entry i actualy have to click the next line then go back to my combo to auto fill the next.

 

[GinaWhipp]

Hmm, not sure why it's delaying but maybe it's you need to force a Save with...

DoCnd.RunCommand acCmdSaveRecord