This is gonna another Weird question from me..excuse me though...:)

[pedie]

Hi, i have form that is linked to a table but not all the fields...
I want to update few fields with DAO Vba and some other field with DoCmd.RunCommand acCmdSaveRecord that is available in form macro...

I know no one will do this kind of thing but i want to know if it is possible to update this datas to same record[as in same row in the table...]

The main reason behind this is that I want my users only to added values but not retrive/view any data updated by someone else....When i link the form/all controls directly to table fields the users can click on next/ctrl + F and search for table data even from from [thats what i came to know]

Or my another question here would be to disable ctrl + F or make the form available only to add data to table and nothing else....no nothing..

Thanks for helping. And sorry if this is very silly question 'm asking...

[/FONT]
[FONT=Courier New]Private Sub Command25_Click()
'save
    Dim rst As DAO.Recordset
    Set rst = CurrentDb.OpenRecordset("REQUESTtb", dbOpenDynaset)
    rst.AddNew
     rst!DL_NBK_ID = Me.DLNBK
     rst!DL_NAME = Me.DLNAME
     DoCmd.RunCommand acCmdSaveRecord
    rst.Update
    rst.Close
    DoCmd.GoToRecord , "", acNewRec
End Sub

 

[Norie]

Pedie

If you only want a form to be used for data entry sets it's Data Entry property to Yes.

If you don't want users to be able to change certain data in a record you can lock the relevant fields on the form.

That would allow them to see the data but not change.

Or if they don't need to see those fields just don't include them on the form.

 

[pedie]

Pedie

If you only want a form to be used for data entry sets it's Data Entry property to Yes.

If you don't want users to be able to change certain data in a record you can lock the relevant fields on the form.

That would allow them to see the data but not change.

Or if they don't need to see those fields just don't include them on the form.

Thnanks alot Norie. I want them to use the field to add data however i cant hide those fields i dont want them to see data/change/delete...because those fields are also used when adding data.

Thanks again

 

[Norie]

Pedie

I'm sorry but that really doesn't make sense.

What do you want the user to be able to see?

 

[pedie]

Pedie

I'm sorry but that really doesn't make sense.

What do you want the user to be able to see?

Just the blank textboxes, comboboxes etc...but i dont want any table data to reflect in this textboxes, comboboxes etc in the form which is directly linked to form. Just add new data and click on save thats it.

 

[Norie]

Did you try setting the Data Entry property to Yes as I suggested?

 

[pedie]

Did you try setting the Data Entry property to Yes as I suggested?

Norie, thats perfect!
Now, my question is what does "Data Entry property to Yes" do?
Thanks again very much!

 

[Norie]

Pedie

Basically it means that the user can only use the form for data entry.

However, if they enter more than one record they can code back to the record(s) they entered earlier.

 

[pedie]

Pedie

Basically it means that the user can only use the form for data entry.

However, if they enter more than one record they can code back to the record(s) they entered earlier.

Thats fine with me....
Thank you very much!