Search results

This is definitely helping me move forward ty very much. I am wondering though if you could explain a couple of things to me. Why on event "After Update" you do you use ".Recalc" and not ".Requery"? What is event "On Got Focus" and why use ".Requery"? Just trying to understand better. :D

I havent yet. Im not sure what you mean. How would I go about doing that? I do appreciate the help ty btw.

The CustomerID is present there because the Job field isnt always required but the CustomerID is. Maybe its still redundant idk. And just to explain a little further I want the info on the form to carry over with the data entered on the subform to the "New_MainData" table. That might just...

Hi still pretty new with Access. I want to have the info from my combo boxes and text boxes to carry over to new records (on tbl "New_MainData"(temporary name)) that I create on the subform as to be a little more efficient. (request of the person I'm making this for.) Form: and in case it...

Wait wouldnt "remove the lookups from the tables" mean deleting them? Or is there a way to remove a lookup from a field without deleting said field?

I've read in a few places that lookup fields should be avoided but I'm not sure why exactly. Should they always be avoided? It's made me feel that I'm doing everything with my database wrong. :banghead: I'm making a database to keep records for a Trucking company that sells soil and different...

Let me setup my issue. I have 3 tables labeled Carrier TruckNumber and Invoice Table TruckNumber has a lookup field Carrier referring to table Carrier field CarrierName. Now what i want to do is in the 3rd table Invoice I want to create a lookup field TruckNumber to table TruckNumber...

Hello, My name is Anthony. I'm a tiny bit experienced with access and am creating a database for my small construction company. Starting some training videos but have mostly learned so far from google, youtube and trial and error. -Anthony