Recent content by shokly

How about if crate a combobox on the form with two columns the first column data to be texts ( null dates, not null dates) and second column data be ( "", Not null) the show only first column by setting zero width in properties, then set this combo as criteria for query by choosing column 1...

Hav you tryed this approach instead of depending of vb code

Just simplify the procedure of opening the 'WeeklyInspections' as follows: let the rowsource of 'BuildingSelect' combo on 'WeeklyInspections' form to be a query from tblBuildings that take the combo 'BuildingSelect' on 'Selectionfrm' as criteria , and just open the form without setting...

how about if you use the below code on after update even on the Total field on subform1 Forms!MainformName.FrmPayment_Detail.form.Gtotal = me.Total

I suppose you can put a Messag box between the codes before the statement requery, to find out if the options are set to each value selected or not, like below: Private Sub grpTypeTrip_AfterUpdate() SetValuesForCurrentTypeTrip End Sub Public Sub SetValuesForCurrentTypeTrip()...

do you need to display all the record information in subform1, if not so, why don't you use a combobox with row source of the records from query of subform1, and put this combo in the criteria of query for subform2, that way it will filter the records you need whenever you select them in the...

Hi, I think you may add the following VBA code to your after update event of the combobox Private Sub yourCombo_AfterUpdate() If youcombo.Selected(-1) Then Dim lastItem as integer Dim lastT as integer Dim i As Long lastItem= yourCombo.ListCount...