Stupid question on updating or deleting using forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jeffreyswilson@gmail.com - 14 May 2007 16:27 GMT

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.

Reply to this Message

Carl Rapson - 14 May 2007 21:42 GMT

> 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
[quoted text clipped - 5 lines]
> 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

Reply to this Message

jeffreyswilson@gmail.com - 15 May 2007 13:42 GMT

On May 14, 4:42 pm, "Carl Rapson" <mr.mxyzp...@newsgroups.nospam>
wrote:

> <jeffreyswil...@gmail.com> wrote in message
>
[quoted text clipped - 18 lines]
>
> 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

Reply to this Message