A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Filtered Form



 
 
Thread Tools Display Modes
  #1  
Old December 5th, 2009, 11:21 PM posted to microsoft.public.access.tablesdbdesign
dsmith via AccessMonster.com
external usenet poster
 
Posts: 11
Default Filtered Form

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200912/1

  #2  
Old December 6th, 2009, 01:49 AM posted to microsoft.public.access.tablesdbdesign
fredg
external usenet poster
 
Posts: 4,386
Default Filtered Form

On Sat, 05 Dec 2009 22:21:22 GMT, dsmith via AccessMonster.com wrote:

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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
  #3  
Old December 6th, 2009, 05:03 AM posted to microsoft.public.access.tablesdbdesign
dsmith via AccessMonster.com
external usenet poster
 
Posts: 11
Default Filtered Form

Thanks fredg,
worked great

fredg wrote:
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.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200912/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:21 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.