Recent content by Road_Warrior

Run a make table on the crosstab and export that

Check your relationships in the relationship window Twice in the last 6 months Ive had a db corrupt and lost a join between a table and a sub table during the repair process.

Try putting on of the rows that is text at the top. I'm pretty sure Access determines the data type from the first row of data

Forms![fmainformame]![subformname].Form![fieldname]

Doesn't matter since ou are referencing the form in a query. As long as the form is open it will work. Is ClientName the control source of the control you are referencing? You need to use the name of the control not the source.

SELECT qryClientData.InvoiceID, qryClientData.InvoiceDate FROM qryClientData WHERE qryClientData.ClientName = [Forms]![FormNameHere]![FieldWithNameHere] ORDER BY [InvoiceDate];

you're welcome

Here are the results TYPEFY Year MA-84 1984 ma-05 2005 ma-06 2006 ma-07 1907 ma-21 1921 MA-01 2001

Try This Year: IIf(IsNull([TYPEFY]),"",IIf(Right([TYPEFY],2)<=Right(Year(Now()),2),"20" & Right([TYPEFY],2),"19" & Right([TYPEFY],2)))

Here ya go Year: IIf("20" & CInt(Right([TYPEFY],2))<2084,"20" & Right([TYPEFY],2),"1984")

No I do not, hense NOT TESTED. Just add a button to formtest and place the code on the on_click event. BTW I believe You'll need to add SELECT to the string as in "SELECT Main.[Effective amount], Main.[ID code] FROM Main WHERE ((Main.[AF product group])=forms!formtest!combo36);"

This IS NOT tested but should be very close to what you need Assumes at least one of your combos will always have data Private Sub Command107_Click() Dim strRowSource As String If IsNull([Combo26]) Then strRowSource = "Main.[Effective amount], Main.[ID code] FROM Main WHERE ((Main.[AF product...

OK I guess the first question before I can help you code this is what should appear in the List Box if one of the Combos is blank or should there always be a value there and you just need to ensure there is before you populate the list box?

Sorry I assumed you were passing combo values to list box with code. If not my answer will be of no help. How are you doing it?

Or Use a query for the recordsource of the form and set the criteria for Name in the query to[Forms]![YourFormName]![YourComboName]