Saving data from form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried to invoke a query(which works perfectly) into a form but the form
later on locked, only viewing the records is possible without adding new
record??
Then we tried to use expression builder directly from the form but the
result is not saved into the table.
How can i solved this problem?
 
Lamya,

Are you able to add/change records from the query? Some types of joins, or
calculated fields in the query, will prevent the query from being updatable.

Make sure the form properities Allow Edits, Allow Deletions, Allow Additions
are set to Yes.
 
There is no calculation in the query, its an update query on certain
conditions and i set everything in the form to ture(Allowedits,
allowaddition,allowdeletion) but still the form is locked????
 
Lamya,

I not sure I understand what you are trying to accomplish. A form is
normally bound to a SELECT query. You could execute an update by changing
bound fields in the form. If you need to update multiple records that is
usually done via an update query which may be launched from the form via a
command button.

Regards,
Leif
 
Back
Top