Stupid question on updating or deleting using forms

[jeffreyswilson]

Can anyone point me to a tutorial on how to use forms to update or
delete exsiting forms? I am not a VB progrmamer, so I would like to do
it using Access controls only. I have created a form to write to a
table, but now I can't see how to pull up existing records bsaed on
the primary key in order to update or delete them. Thanks very much
for pointing me in the right direction.

Jeff Wilson
P.S. if it matters, I am using Access 2003.

 

[Carl Rapson]

Can anyone point me to a tutorial on how to use forms to update or
delete exsiting forms? I am not a VB progrmamer, so I would like to do
it using Access controls only. I have created a form to write to a
table, but now I can't see how to pull up existing records bsaed on
the primary key in order to update or delete them. Thanks very much
for pointing me in the right direction.

Jeff Wilson
P.S. if it matters, I am using Access 2003.

You can locate records using the Filter By Form tool on the menu bar. Click
the Filter By Form button, enter the primary key you are interested in (you
can even use wildcard characters), and click Apply Filter. Look in Access
Help for more information on Filtering and wildcards.

HTH,

Carl Rapson

 

[jeffreyswilson]

You can locate records using the Filter By Form tool on the menu bar. Click
the Filter By Form button, enter the primary key you are interested in (you
can even use wildcard characters), and click Apply Filter. Look inAccess
Help for more information on Filtering and wildcards.

HTH,

Carl Rapson

Carl

Thanks! I will look at that. But I want to create a form that can be
used for inquiry, not use Access tools.
This will be distributed to a user and I want an easy interface. But I
will look at it..thanks again!

Jeff