Filtered Form

[dsmith via AccessMonster.com]

I have been using the Northwind database as a learning tool to improve my
knowledge of the system. I recently incorporated the "Customer Phone List" to
my application but I was wondering if there is a way to allow new records to
be added on the form as opposed to returning to the source table. Since the
info displayed on the form is filtered, it does not give you that option.
thanks

 

[fredg]

I have been using the Northwind database as a learning tool to improve my
knowledge of the system. I recently incorporated the "Customer Phone List" to
my application but I was wondering if there is a way to allow new records to
be added on the form as opposed to returning to the source table. Since the
info displayed on the form is filtered, it does not give you that option.
thanks

That Phone form is not designed to permit data entry nor is it
suitable for that.
Even if you change the AllowAdditions property to Yes (it's currently
NO) you still need to enter a CustomerID, Address, City, etc., which
the Phone form does not show.

An easy method to add a new customer is to code the Customer Name
control's Double-Click event:

DoCmd.OpenForm "Customers", , , , acFormAdd

Double-clicking on the Customer control will open the Customer entry
form. Enter the new customer information, close that form, and this
new customer will appear on the Phone form.

 

[dsmith via AccessMonster.com]

Thanks fredg,
worked great

That Phone form is not designed to permit data entry nor is it
suitable for that.
Even if you change the AllowAdditions property to Yes (it's currently
NO) you still need to enter a CustomerID, Address, City, etc., which
the Phone form does not show.

An easy method to add a new customer is to code the Customer Name
control's Double-Click event:

DoCmd.OpenForm "Customers", , , , acFormAdd

Double-clicking on the Customer control will open the Customer entry
form. Enter the new customer information, close that form, and this
new customer will appear on the Phone form.