Re: SOS! How to add new record to many to many relationship using a fo

PS you also need to requery the combobox to make the change show up.

HTH;

Amy

"Amy Blankenship" <Amy_nospam@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ew5w2lGwFHA.2232@xxxxxxxxxxxxxxxxxxxxxxx
>
> "Rich1234" <Rich1234@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:368CBBB7-16F0-4927-AB3F-DDFDA1886D3A@xxxxxxxxxxxxxxxx
>>I have also tried an "Add new driver" button on the main form, which opens
>>a
>> form to add a new driver. Once again, I can add a driver to the drivers
>> table (without errors) but can't add an entry to the VehiclesDrivers
>> table.
>> I have tried including the VRM field in the add new driver form but it
>> appears blank when the form is opened in Add Mode. What am I doing
>> wrong?
>> Do I have to add to the drivers table first, before adding a new record
>> to
>> the VehiclesDrivers?
>
> On your add new driver button, make sure you set the OpenForm action to
> open the form as a dialog (acDialog). Then, in the form's unload event,
> cancel the unload if it was called by your button (look at OpenArgs), and
> instead make the form invisible. Now, you have access to the new driver
> in the other form to add to your calling form. After you add the driver,
> close the popup form.
>
> HTH;
>
> Amy
>


.