Search results

Brilliant - thank you again arnelgp

The db above was a training db and based on your advise I got it working but when I went to do it in my actual db - it seems to have a problem with requery?

Thanks arnelgp - I did both of these - thank you

Wow! Thanks MajP .... Savant indeed

I know I'm close but just need some help with the attached please. The Product Type is the parent and the Product Sub Type is the Child. Just want to show the filtered fields in the child when the parent is selected in the form. Thanks AdelaideKiwi

Perfect - thank you arnelgp

Hi Uncle Gizmo, I have a table called 'tblPostcode'. A postcode can have a number of suburbs. Each Suburb only has 1 postcode and 1 state. NT means Northern Territory

Thanks CJ - it worked perfectly but I need the prefix of 21 - xxxx

Hi Arnelgp, Private Sub Form_BeforeInsert(Cancel As Integer) Dim strNewLeadNum As String Dim v As Variant strNewLeadNum = Nz(DMax("LeadNo", "tblLeadGeneration", "[LeadNo] like " & Left$(Year(Date), 2) & "*"), "") If Len(strNewLeadNum) < 1 Then strNewLeadNum = Right$(Year(Date), 2) & "-0001"...

I would like my form to auto populate the state and postcode based on the 'after update' of my suburb please. Thanks AdelaideKiwi

Hello All, This is my first post so bare with this newbie. This has probably been answered before so perhaps a point in the right direction might be good. I have a table/form called "Lead Generation" It has a field called "Lead Number". It is not the primary and is not an autonumber. I want it...