Update a record

[Qwan]

I'm using Access 2000 and 2002. I'm trying to find away
that will allow me to update a record on a form. Also,
I'm using the switchboard and trying to create a search
form which I was able to do but when I pull up the search
form it automatically pulls up the last record I searched
instead of going to a black record so I can input my
search info. How do I make it go to a blank record
automatically?

 

[John Vinson]

I'm using Access 2000 and 2002. I'm trying to find away
that will allow me to update a record on a form.

Ummm...

Open the Form. Start typing. Move off the record. The record is now
updated.

Updating records with a form is what forms are primarily designed to
DO. Evidently you're having some difficulty - could you explain what
that difficulty might be?

Also,
I'm using the switchboard and trying to create a search
form which I was able to do but when I pull up the search
form it automatically pulls up the last record I searched
instead of going to a black record so I can input my
search info. How do I make it go to a blank record
automatically?

The Search form should be UNBOUND - that is, it should have *no*
recordsource property. If you pull up an existing record and start
typing, you'll overwrite that record with whatever you type; if you go
to the "blank" new record, you'll add a new record to your table
consisting of your search criteria. Neither of these is a desirable
outcome, generally!

Just make the search form unbound and use the wizard-generated VBA
code to create a search; or use the built in Query By Form option from
the menu or toolbar to make a bound form into a searching tool.

 

[Sue]

Make an AutoLookup query. Someone else will have to tell
you how, because I'm pretty new at this!