automatic field update
Posted on 1998-09-06
I have an access 8.0 backend database. one of the tables is my zipcode table which is composed of zipid, zipcode and county, as a county can have several zipcodes, some may be repeated. I have a vb 5.o front end. I would like it that when the user enters a zipcode, that the corresponding county appears, or if that county is not in my list to prompt for addition. I have a seperate box (cbo, etc)for the state, county and zipcode. I know that in access i would use dlookup. any help would be appreciated. do i have to create a seperate recordset?