Regarding entry from the form in to the DB tables.

[rushitshah]

Hello..
I am doing data entry in the tables from the form.

The thing is that the form when opened goes on the first record of the database and displays what is there. If I change something it is directly updated in table.

If I mark form's data entry field as YES then, it does not show the records.

What I want, Is there some way that the user can only see the record on the form but can not change it!! or a window can be popped up if they are about to change something??

Thanks for the help,
Rushit..

 

[missinglinq]

As usual, there are a number of ways to accomplish your goals. The simplest way would be to have two identical (in appearance) forms.

The first form would be for you (or whoever)to enter, edit or delete records. Limit access to it by using a password on the form. For this form set its properties like this:

Allow Edits = Yes
Allow Deletions = Yes
Allow Additions = Yes
Data Entry = No

The second form (just copy the first form and give it a new name) would be for users to just view the records. For this form set its properties like this:

Allow Edits = No
Allow Deletions = No
Allow Additions = No
Data Entry = No

As I said, this is just one way to accomplish your goals, but probably the easiest, since you simple have two copies of a form (which you already have designed) and just set 3 properties differently for each.

Hope this helps!

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[rushitshah]

Hey Missinglinq..

Where are these options? In the properties of forms or should I include it with VBA coding?

And is this going to work for unbound form too??

Thanks,
Rushit..

 

[GingerR]

You can use one form and set those properties depending on how you want to use it. Form a switchboard form have two buttons, "ADD RECORD" or "VIEW RECORDS". OnClick of "ADD RECORD", open the form and go to acNewRecord. In OnClick of "VIEW RECORDS", open it in ReadOnly view, or set AllowEdits to NO. Put a button on it that the user has to click to set EDITS to YES, or unlock the form some other way. Lots of diff ways to do it depending on what you want. Read up on FORM Design and Properties.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html