Recent content by swift_ingress

Thanks Mick. So I removed: tbl_Countries.AddNew tbl_Countries!CountryName = NewData and added this code (actually I'll put all the code from the last working line): dim strSQL as string DoCmd.OpenTable ("tbl_Countries") strSQL = "Insert Into tbl_Countries ([CountryName]) " & _...

Hi, I'm creating a simple Country/State/City/Street database as a test bed for other applications. The Country/State/City/Street are each their own tables. State has StateID(PK), StateName and CountryID(FK). City and Street are identical (they only hold the ID(FK) for direct parent). On the...

Thanks DBguy, that Not in List event seems to be what I'm after. This looks like it suits my needs. It seems that the things I want to do with Access are going to require that I have a much more in-depth knowledge of Access and VBA in particular. If you have any study guides, websites or...

Hi all, I have a simple cascading combobox form: Vehicle Manufacturers and Vehicle Models (this is just a test case for proof of concept). Values are: Ferrari Modena Ford GT I'm trying to setup a button so that if a field value doesn't exist, the user can create a new record without...