Running a formula on all entrys retrospective

[Krays23]

HI

Can you help me ?

I have added a formula to a combo box to update a bunch of other txt boxes on my form how do I apply these to all records already there?

The formula works fine if I re click the combo box but I have over 1000 records and I don't wat to go click all them!!!! how can I get it to re run to apply to all?

Cheers

Dan

 

[Ranman256]

not sure what youre asking.
Combos don't usu have formulas, they have data records from a query.

When you click the item in the combo, what is supposed to happen?
If you want to apply changes to records, you run an update query.
pls explain further.

 

[jdraw]

Your post is a bit unclear. Normally forms are populated with data from Tables. If there is/are some field/s in your table (or tables), you could write a small procedure or query to
modify/update the field/s.

More info and specifics required for more detailed response.

 

[Krays23]

Your post is a bit unclear. Normally forms are populated with data from Tables. If there is/are some field/s in your table (or tables), you could write a small procedure or query to
modify/update the field/s.

More info and specifics required for more detailed response.

Hi

my combo box populates other text boxes on my form when I click it.

I have only just written this to do this and now the old records don't sho it unless I re click that combo box then all the data for the 16 colums pops into the form and populates the table

What I need is for it to do this automatically update query sounds good how do I build that

 Private Sub cboMSN_Change()
Me.TxtStratashipset.Value = Me.cboMSN.Column(1)
Me.txtLayUpCRS.Value = Me.cboMSN.Column(2)
Me.txtAutoClaveCRS.Value = Me.cboMSN.Column(3)
Me.txtCNCCRS.Value = Me.cboMSN.Column(4)
Me.txtNDTCRS.Value = Me.cboMSN.Column(5)
Me.txtQualityGate2CRS.Value = Me.cboMSN.Column(6)
Me.txtMRBCRS.Value = Me.cboMSN.Column(7)
Me.txtSurfacePrepCRS.Value = Me.cboMSN.Column(8)
Me.txtSuperMarketCRS.Value = Me.cboMSN.Column(9)
Me.txtAssyinJigCRS.Value = Me.cboMSN.Column(10)
Me.txtAssemblyoutofJigCRS.Value = Me.cboMSN.Column(11)
Me.txtPrimerandTopcoatCRS.Value = Me.cboMSN.Column(12)
Me.txtPaintRepairCRS.Value = Me.cboMSN.Column(13)
Me.txtFinalInspectionCRS.Value = Me.cboMSN.Column(14)
Me.txtSourceInspectionandPackingCRS.Value = Me.cboMSN.Column(15)
Me.txtExpectedDeliveryHUBCRS.Value = Me.cboMSN.Column(17)

 

[jdraw]

Can you step back and tell us WHAT you want to accomplish? Forget the combo and text boxes for the moment---just plain English. Same terminology as you would tell a 6 year old who has no idea of database or you or your business.

 

[Krays23]

Can you step back and tell us WHAT you want to accomplish? Forget the combo and text boxes for the moment---just plain English. Same terminology as you would tell a 6 year old who has no idea of database or you or your business.

I would like to update all records with all formulas without clicking

 

[Krays23]

Your post is a bit unclear. Normally forms are populated with data from Tables. If there is/are some field/s in your table (or tables), you could write a small procedure or query to
modify/update the field/s.

More info and specifics required for more detailed response.

HI

Can you tell me what small procedure that is?

Basically I want the form when I go to next record to re check all data

I have a number of text boxes now linked to colums in a combo box that were not when I first built the db

How can I get it to re check and fill out with out re clicking the combo box