Access Form

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

Guest

I am building a basic form that the user can enter data into. (just 1 table)

I am gettin "From" and "To" Dates from the user
how do i display data that the user could edit based on the From and To Date??

I tried giving the data source for the form as a query, but in this case
user cannot edit data.

Please Advice, I really need any advice for this.

Thanks a lot!!!
 
Use the query you built to get the data from the table and then use another
query in you code (or DAO, or ADO) to update the data in your table.
Be sure to have some code to check what user enters.

Rocco
 
Hi - I have never use ADO or DAO before for my forms, could you please help
where this code goed.

I have the records from the query ready to be on the form, now i need to
edit info on the form.

Wher do i use the VB Code here??

Thanks a lot for your help.
 
I will need more info to help you out properly. Do you have any knowledge of
VBA coding?

Rocco
 
If you are only updating one table, why is your query not updatable?

The simplest approach would be to see if your query can be adjusted to
support updates. If you share the SQL, we might be able to address that.

HTH,
 
Back
Top