Blank form on Form load

[sajitk]

Friends,

In Access whenever a form is loaded, it normally shows the first record in the table. wat i want is that, whenever a particular form is loaded, it should not show any record....that is, it should be in Add Record mode.

would be great if you could help me on this.

Sajit

[janders468]

Use a select query on the table you want to add to but give a required field a criteria of is null.

[JustJim]

Use a select query on the table you want to add to but give a required field a criteria of is null.

Or... You could set the "Data Entry" property of the form to "Yes"

or, if you open the form using VBA, use the "Data Mode" = "Add" argument of the "Open Form" action.

Jim

[sajitk]

gr8...it works...

I have one more problem...i want to insert the logo of my orgnization.... but when i insert that, the logo doesnt adjust with a frame....what is the best way to add pics in access.....

the logo is a jpeg file.

thanks
Sajit

Or... You could set the "Data Entry" property of the form to "Yes"

or, if you open the form using VBA, use the "Data Mode" = "Add" argument of the "Open Form" action.

Jim

[JustJim]

gr8...it works...

I have one more problem...i want to insert the logo of my orgnization.... but when i insert that, the logo doesnt adjust with a frame....what is the best way to add pics in access.....

the logo is a jpeg file.

thanks
Sajit

Hi Sajiit, glad it worked.

In the "Format" tab of the Properties Sheet for an Image object is the property "Size Mode" property. It can be set to "Clip", "Stretch" or "Zoom".

Have a play with those settings, they're fairly self explanatory.

Happy Easter (if you do, if you don't then forget I mentioned it!)

Jim

[sajitk]

Hi Jim,

Thanks....Happy Easter to you too....

hope you had a blast during Easter.

Sajit

Hi Sajiit, glad it worked.

In the "Format" tab of the Properties Sheet for an Image object is the property "Size Mode" property. It can be set to "Clip", "Stretch" or "Zoom".

Have a play with those settings, they're fairly self explanatory.

Happy Easter (if you do, if you don't then forget I mentioned it!)

Jim