How do i open a datasheet entry in the form view

[Guest]

I have recently started to build a database for my business, i have also
created a form which i am able to enter all the data required for each entry
and also includes photos. My form works fine and each new entry is added to
my database. I am however having problems with trying to open up an existing
database entry in the form view, so i can easily view the record and the
images. When i do open my form, the form is blank and i am unable to open any
previous entires i have opened.

I have seen in the various templates, that if u are in the datasheet view
and you double click on a particular aspect of the entry it opens the data
entry up in the form view and all the details can be easily view. I am
wondering if anyone would be able to offer me any advice, thank you

 

[Scott McDaniel]

I have recently started to build a database for my business, i have also
created a form which i am able to enter all the data required for each entry
and also includes photos. My form works fine and each new entry is added to
my database. I am however having problems with trying to open up an existing
database entry in the form view, so i can easily view the record and the
images. When i do open my form, the form is blank and i am unable to open any
previous entires i have opened.

You might be opening this in the DataEntry mode ... how are you opening your form? If you're doing so with a Button, can
you provide the code behind that button?

I have seen in the various templates, that if u are in the datasheet view
and you double click on a particular aspect of the entry it opens the data
entry up in the form view and all the details can be easily view. I am
wondering if anyone would be able to offer me any advice, thank you

This would be an "event driven" process (i.e. the user performs an action, the database responds to that "event") ... so
when the user DoubleClicks a record, you would write code that would tell Access to open a particular form, and go to a
particular record. Rather than show you some code examples, you might consider looking into the samples provided with
Access. The Northwinds database provides this type of functionaliyt (and much more) so a good place to start would be
there.

There are also other samples which may be helpful:

http://office.microsoft.com/en-us/templates/CT101172481033.aspx

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com