Ask Your Question

can be update database using same form which used for saving data

asked 2016-11-05 20:36:13 +0200

koolninja gravatar image

i have created form which used to save data to tables as required but some of data need to be regularly updated. i don't want go to backhand to update data. i need search previous data and update it. i need some tips to perform this task .

thank in advance

edit retag flag offensive close merge delete


"...need search previous data..." is not clear. Are you looking for specific records? Certain values in fields? More information please.

Ratslinger gravatar imageRatslinger ( 2016-11-05 20:59:10 +0200 )edit

Also, what about using the Find Record tool (magnifying glass) on the Navigation Bar?

Ratslinger gravatar imageRatslinger ( 2016-11-06 01:49:59 +0200 )edit

i will try find record, its may solve my problem. i will update comment with respect to it, after applying this

koolninja gravatar imagekoolninja ( 2016-11-06 15:29:51 +0200 )edit

i am using navigation bar for saving forms. during working session i can navigate through previous data saved at during that session and can update if required from previous saved data of that session. next load new initial count loaded cant't be navigated through this previous saved session data. as i mentioned earlier that some of data need to be regularly updated as change of data occurred of same primary key no which was saved previously.

koolninja gravatar imagekoolninja ( 2016-11-07 07:56:36 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-11-07 17:05:18 +0200

Ratslinger gravatar image

Based upon your last comment, you seem to be saying during a session you make record changes and can go back and see them. Once you close the form and re-open the changes are gone.

When you re-open the form and the changes seem to be gone have you looked at the actual table entries to see if they are there? If they are there, are you just going by the record number in the navigation bar? If the record bar shows 1 of 41* the * means there are more records and only 41 were loaded into memory. Clicking the Last Record button on the navigator will load all the records.

If you don't find the changes in the tables themselves, you must be doing something with macros that affect the data. If so, a complete sample (without personal or confidential information) is necessary to determine what is going on.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-11-05 20:36:13 +0200

Seen: 25 times

Last updated: Nov 07 '16