Can't Update Data in Form - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Can't Update Data in Form

Mara Lucic

2 years ago

Hi! I have an issue with updating an existing information via form. I have rental inventory database with order system. Everything is working ok when creating new order. Forms used for that are letting me input information with no problem. Issue happens when i want to pull an existing order and change few values when needed. Tables used for this are

OrderT - table containg infomation about an order as a whole
OrderDetailT - table containing infomation about inventory items added to the order

I have read about possible conflicts when form is using more than one table, however, my form OrderF contains infomation only from OrderT in parent form and subform contains infomation form OrderDetailT with rental items details. I am able to update infomation in subform with no isse but information in parent form from OrderT is not letting me change infomation. I tried creating an intermediate small single form that pop ups when clicking on field in OrderF form that only has 1 source in OrderT referencing OrderID to open that specific record and it still doesn't let me change it. However if i close all the forms and i only run same intermediate form with orderT info, then it is letting me edit the info. Of coure form opens on first possoble record from OrderT table (not specific record). What am i doing wrong and why am i able to update infomation in subform but not main form?

	Mara Lucic OP @Reply 2 years ago

	Mara Lucic OP @Reply 2 years ago

	Mara Lucic OP @Reply 2 years ago

	Mara Lucic OP @Reply 2 years ago

	Richard Rost @Reply 2 years ago
Is your Allow Edits property set to Yes?

	Mara Lucic OP @Reply 2 years ago
yes it is, checked all the settings.

	Richard Rost @Reply 2 years ago
Turn on the navigation buttons on the bottom that will show you if the record set is editable. If you don't see an "Add New Record" button that's enabled, that means that your record source for some reason is Not Updateable.

Mara Lucic OP @Reply

2 years ago

OK, i did add navigation buttons. It is editable if i open OrderF form alone. Problem seems to be when i get to that form from OrderSearchF and form opens to specific order. If i opened OrderF alone and looked for specific order to update by browsing through all the orders with navigation buttons i could eventually update specific order. However, that is not feasible due to number of orders and i need to be able to search it up first.

	Kevin Robertson @Reply 2 years ago
Sounds like your button may be opening the form as Read Only. What is the code behind the button?

Mara Lucic OP @Reply

2 years ago

Hi Kevin, i used this line on the button

DoCmd.OpenForm "OrderF", , , "OrderID=" & OrderID

you can see entire code for that form below

Details

Private Sub SetDefaults()



IsQuoteSearch = Null

OrderNumberSearch = ""

CustomerSearch = ""

OrderDateSearch = ""

CustomerJobNumberSearch = ""



End Sub





Private Sub ClearSearchBtn_Click()

SetDefaults

Me.Requery



End Sub





Private Sub Form_Load()

DoCmd.SetOrderBy "orderid desc"

End Sub



Private Sub OpenBtn_Click()



DoCmd.OpenForm "OrderF", , , "OrderID=" & OrderID



End Sub



Private Sub OrderDate_BeforeUpdate(Cancel As Integer)



End Sub



Private Sub RequeryBtn_Click()

Me.Requery

End Sub

	Mara Lucic OP @Reply 2 years ago
actually, i also had button command in macro. I removed macro and left code alone to open that form and now when i click on button nothing happens.

	Kevin Robertson @Reply 2 years ago
Is your database in a Trusted Location?

	Mara Lucic OP @Reply 2 years ago
Now i have deleted and created new button, chose data mode edit. It opens form to correct record but still can't type. It is the same on another form i created to test it and it is also sourced from OrderT . I am starting to think it is only happening with data from table OrderT.

	Mara Lucic OP @Reply 2 years ago

	Mara Lucic OP @Reply 2 years ago
i would say it is in trusted location. I am not getting yellow band warning to enable contents every time i run this file. I have specified trusted location in settings.

	Mara Lucic OP @Reply 2 years ago

	Mara Lucic OP @Reply 2 years ago
Any ideas what is wrong? I am on a deadline and stuck on this issue for a week running late. Any help would be greatly appreciated.

	Adam Schwanz @Reply 2 years ago
It doesnt look like you have the trusted locations done, just the default

	Mara Lucic OP @Reply 2 years ago
i added specific folder where i have my database stored. Restarted Access and it still doesn't let me edit.

	Mara Lucic OP @Reply 2 years ago

	Richard Rost @Reply 2 years ago
What is the RecordSource for the form you're not able to update?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View