Navigation Form

[Rmaster2022]

I am using a Navigation Form. One of the subforms is frmOcupation. On that form is a button which opens a popup form, popupOccupationAdd, in which I can add a new record. I have a where expression that automatically inserts the memberID from frmOccupation. I enter the remaining information manually. That is working fine.

I want to be able to requery, close popupOccupationAdd, and return to the same person’s record in frmOccupation. Do I use “browse to” to get back to frmOccupation? I am having trouble writing a where expression so that when I close the popup frmOccupationsAdd I will return to the same person’s frmOccupation record.

 

[theDBguy]

Hi. It's quite possible BrowseTo is what you need, but it might help figure out the where expression if you could post a sample db.

 

[Rmaster2022]

Are you saying that you have separate forms to view and add the same data?

Yeas

 

[Rmaster2022]

Sorry to be slow, but I have finally reworked my database based on your recommendations to simplify things and reduced the forms.

The help I need is in the form ‘Occupations’ under the Pastors tab. There are three subforms, one under the Current heading, another under History, and another under Add. The criteria for the query for the Current subform is based on the EndDate field, “Is Null or >Date()” The criteria for History is “<Date()” What I want to do is to have the History or Current subforms requery (and/or refresh?) after adding a record and clicking on “Save Record” within the Add subform.

One other item is the church combo boxes in all three subforms. When a congregation is dissolved, I want a conditional format so that the font is red for a church that is dissolved. I have done these, but evidently cannot get the expression right. Dissolved is indicated by placing a date in the Dissolved field on the Congregations form.

I have attached the file with some records.

 

[Rmaster2022]

Yes, I didn’t understand, and I still may not. It is obvious that I am not an expert in ACCESS, nor do I claim to be competent in ACCESS.

I changed the Occupation form to not have 3 subforms. Any records that are “History” I added a conditional format.

I think I removed the special characters.

Is it OK to have “ID” included in the PK name, not be solely “ID”? Example: Candidate ID

I validated fields within the tables.

I don’t understand what you mean by the relationship comment. I do have 2 tables that are not related, for a good reason.

Are you willing to take a quick look at my database design again? I’d like to privately send you what I have now. I prefer that you review with my real fields, and so I’d rather not make it public.