469,167 Members | 2,201 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

How to create a form to use for data entry and lookups?

167 100+
I am using MS access 2007. I want to create a form that when opened will contain all blank columns (to do this I believe I do not include a record source on the forms property). I want the user to be able to enter a number in a column called 'asset', hit enter and the form populate with the data for this asset. Also allow them to type over any data column and change the values.

I also want to be able to clear the form (if any data showing) and allow user to enter a new record.

Is there any way to do this without having to create 'add new rec' or 'search' buttons?
Jan 11 '11 #1
1 2175
Stewart Ross
2,545 Expert Mod 2GB
Hi. Sorry for the delay in replying. Whilst it is technically feasible to do some of what you suggest it is a great deal of work, in effect recreating what Access already does for you but entirely under your control.

It is much, much simpler to use a bound form for the display, entry and editing of your records. On that form you can place an unbound combo box as a look-up for entry of the asset number, using code in its After Update event to filter the appropriate tables within the recordsource of the bound form to retrieve the correct record.

You would still need some form of Add New button on your form, and indeed you should think carefully before introducing methods of navigation which users would not be familiar with. Methods involving shortcut keypresses or unfamiliar actions used in non-intuitive ways are unlikely to be met with anything other than confusion by all but advanced users of the DB. A button labelled "New Record" is at least familiar and self explanatory!

-Stewart
Feb 6 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by John | last post: by
6 posts views Thread by ye2127 | last post: by
7 posts views Thread by rameshch45 | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.