[OBP]

There are a number of different ways to do this, the first is to use the Combo's "not in list" event procedure. The user enters a Flight Detail in to the Combo and it is not already in the database, it can be added to the Flight Detail table or it can be used to open the Flight Detail table to add all of the data.
Another would be to use a tabbed Form where the other forms are also available at a click and when the data is entered it is made available to the other form.
Obviously it is best to put as much data in to the database at the beginning.

[Yoshiaki]

Sorry for the late reply, has been very busy for the past few days.

I have finally somehow sorted out my problems. Previously, I got a problem is that when I input data in the Flight_Details, Aircraft, Operators and Organisation, it will not be updated immediately on the Audit tab form.

The main form of that tab form is my Inspector. It was then I discovered that even though the other attributes like "Flight_Details, Aircraft, Operators and Organisation" are not really related to Inspector (the main form) but it will also need to include a foreign key to link to the main form. So each of the tables I added in InspectorID. After that, just re-arrange the tab order, and it should not be a problem.

Thanks for all the users who had replied this thread. The biggest credits go to OBP, who shown me a sample of a tab form. And really thanks a lot for your patience with me!!

[OBP]

Yoshiaki, it is my pleasure, well done in sorting it out.