First, using upper and lower cases will make your name easier to read: it's
much better to write ExhibitorShowBooths instead of EXHBITORSHOWBOOTHS.

In your last answer, you did't tell us if you have been able to write the
ResyncCommand and set the UniqueTable properties for both the form and the
subform.  By searching this newsgroup with Google, you should easily find
some examples on how to use them.

Finally, without telling us the record source that you have used for both
the main form and the subform, it's impossible to understand the error
message that you are showing us.

Sorry that I am not explaining this very well, it is pretty complicated
application (for me) I will try and explain it better.  Just an FYI, I am
using an instead of insert trigger with in this application to update 2
tables at one time (probably not the best solution but it works).  The
scenario that I am currently seeking help on is as follows: There are
basically 4 tables involved Shows S, Exhibitors E, ExhibitorsShows ES and
ExhibitorShowBooths ESB.  The relationships are as follows: the ES table is
used to handle the many to many relationship between S and E.  (one to many E
to ES and one to many S to ES)  The relationship between ES and ESB is also
one to many) The user can add a new Exhibitor (populates the Exhibitors
table) and then can add them to the Show by clicking on a command button (as
soon as this happens I added an insert statement to populate the ES table)
The user then can add booths for that exhibitor (which is one of the subforms
on the main form, the main form is the form used to add exhbitors)  At this
point, Access ‘tries’ to insert a row into the ESB table but I get the
following error:  “Invalid input parameter check the status values for
details”

Main form RecordSource is set to:

       strSQL = "SELECT ES.ExhibitorID, E.ExhibitorShortName,
ES.ExhibitorShowID, " & _
                   "E.ExhibitorName, E.Notes, E.ProductDescription, " & _
                   "E.DivisionID, E.ShowCategories, E.NewExhibitor " & _
               "FROM ExhibitorsShows ES " & _
                   "INNER JOIN Exhibitors E ON ES.ExhibitorID =
E.ExhibitorID " & _
               "WHERE showid = " & " '" & pubShowID & "'" & _
               "ORDER BY E.ExhibitorShortName "

Subform RecordSource is set to

strSQL = "SELECT ES.ShowId, ES.ExhibitorID, ESB.ExhibitorShowID,
ESB.BoothName " & _
           "FROM ExhibitorsShows ES " & _
           "INNER JOIN ExhibitorShowBooths ESB ON ES.ExhibitorShowID =
ESB.ExhibitorShowID " & _
           "WHERE showID = " & "'" & pubShowID & "' " & _
           "ORDER BY BoothName"

If I have the subform set to the above recordSource, I can not even add
booth number (does not let me type anything into the text field)   If I have
the above RecordSource BUT NO where clause,
I get the following error: “Invalid input parameter check the status values
for details” I have the subform’s Link Child Fields and Link Master Fields
set to ExhibitorID

I am at a complete lose and have no idea on what to do to fix this

Again any help would be greatly appreciated
ToniS