Cascading Combo boxes

[finsmith]

Sorry this got posted in the wrong forum.


Hello Again.
I am having an issue with my combo box. The code I am using is not populating my other boxes.
attached is my database. and form.
This is the code I am using for the combo box.
It is not pulling in the data from the query.



Private Sub Combo69_Change()
Me.txtMATL_.Value = Me.Combo69.Column(1)
Me.txtFINISH.Value = Me.Combo69.Column(2)


End Sub

I have several other fields that need to be filled in.
I was hoping that this would work but it is not.
Any other ideas by chanceblank (3).zip

[pbaldy]

I can't look at the sample right now, but make sure the column count property of the combo is correct.

[finsmith]

it is correct. Ive been trying....
ive also tried this too
Private Sub Combo73_AfterUpdate()

Me.txtFINISH = DLookup("parts_finish", "mml_lom_1", "parts_id = '" & Me.Combo73.Value & " '")

Me.Combo73.Requery

[pbaldy]

Are you sure you've enabled code or put the database in a trusted location? The code is working correctly for me.

[finsmith]

SH*T out of my a$$
thanks baldy
i want to go and cry now

I was doing this


Private Sub cbodescp_Change()
Me.txtMatl.Value = Me.cbodescp.Column(1)
Me.txtSPEC.Value = Me.cbodescp.Column(2)
Me.txtManufacturer.Value = Me.cbodescp.Column(3)
Me.txtMFG_MODEL_NO.Value = Me.cbodescp.Column(4)
Me.txtELEC.Value = Me.cbodescp.Column(5)
Me.txtFINISH.Value = Me.cbodescp.Column(6)
Me.txtUNIT_WT_LBS.Value = Me.cbodescp.Column(7)



will dlookup work for a web based form?
I k now column does not

[pbaldy]

Well, you can't have VBA in a web form. The column bit I think is fine, you just do it with a macro instead of VBA. The action is either SetValue or SetProperty, I can't remember which does it now (used to be SetValue).

[Missinglinq]

...will dlookup work for a web based form...

I don't do that type of thing, but I believe that no VBA code works on web-based forms! I believe that I've read that you have to use all Embedded Macros, instead of code.

I could be wrong; as I said, I don't do web-based apps!

Linq ;0)>

[finsmith]

Going to revisit this. Does anyone know how this can be done in a web database?
macros or using vb?

[Missinglinq]

As Paul and I have said, you cannot use VBA code with web-based Forms. And unfortunately, from your standpoint, few of the experts, here, utilize Macros, with the exception of a specialized Macro named AutoExec, which fires when an Access Database first opens.

Linq ;0)>

[finsmith]

Just to be on the safe side, what do you think of these replies:
If you can respond I appreciate it

http://social.msdn.microsoft.com/For...f-2fdae7100141

http://social.msdn.microsoft.com/For...4-e8798a547053

http://social.msdn.microsoft.com/For...7-36d3e3d070aa

[pbaldy]

I got no further than the first reply on the first thread. Albert probably knows more about web databases than the people at MS. I'd do whatever he recommended.