Search results

Do you have to create the subform from a Query? Isn't it possible to create a form from multiple sources? ... that when data is entered, the corresponding tables are updated?

Jack, Just reviving this thread to see if maybe I could get this resolved. Any further assistance in this would be greatly appreciated. Thank you again. Jon

Let me prefix this reply by saying that I don't know @$% about VB and I'm self taught for the most part when it comes to access. That said, I had a similar situation. A parent/child relationship problem where they were connected by a common PrimaryID. The two forms were tabbed. The data...

Jack, Maybe a key piece if information as well. The search field is on a child form called "Filtered Data". The parent form is called "Demographics1". here is the code so far, Private Sub MRN_Number_AfterUpdate() If Me.NewRecord Then If Not IsNull(DLookup("MRN_Number", "Demographics"...

Chuckster, Not sure if that is a statement or a question. Either way, I wouldn't have a clue.

Jack, I appreciate your reply. The code had a compile error. I'm guessing that part of the problem lies in the fact that my primary key is named "MRN Number" It was only after I had completely built the db did I learn that it wasn't a good idea to have spaces in your field names. At any...

I'm on a mission to find out the following: On a form, if the patientID is entered (primary key) and the record already exists, instead of getting the standard MS ACCESS error message about not being able to create duplicate records... have a message bx appear stating that a record currently...

Does this have to be a combo box? Can it not be a true text box?

This sounds great, but I would prefer to not use a combo field... and work this from a text field.

A novice here. I created a db for info on hospital patients. The Primary Key (no duplicates)is an ID number assigned by the hosptial, and is therefore not auto-created by Access. My goal is for the patientID field on the data input form - on enter - scan the DB for the ID, and if already...