Recent content by Core

I have two forms. Form one, based on a query Form two, based on specific record said query When form two closes I would like form one to refresh with any changes made to the table/record and update itself. Any advice.

Yeah they were not the real field names. Thanks a lot for that walk through, very helpful and worked a treat.

I have 2 tables like so: 1: ID Name NIID* 2: ID* NAME My form is based on Table 1, and has a combo box linked to the NIID field. I whish the drop down to displace the records table 2 and once selected his name to appear as the text in the combo box. Is that doable and how?

Ah I thought so :) That field is a grab of the time/date when a change is made. So on the form when ever a change is made VBA updates that field with the date.

Is the LatestUpdate the field titled: "Last Updated" or is it a property? I added the design view for the query also in the last post.

I can add the ID or Date field form the notes table.

I cannot use imageshack at work. I attached it instead however it has made it a little smaller... text might be hard to read, sorry.

Ignore that. I have double checked and it shows a record for each learner per update. I only want the latest update to be shown.

Should I upload a screenshot?

Thats great, however it does not show the most recent update, any way to sort which one it shows?

Hello, I have two tables. One is a list of clients and the second is for update notes. Each client may have several notes (one to many relationship). What I want is a query that will show each client and there most resent update... but still show the client even if they have no update. When I...

Okay I found the solution. For anyone thats interested: DoCmd.RunCommand acCmdUndo

Hello, I have a form that opens up a record for the user to view and edit. I would like the form to have a save and cancel button. The save button is fairly simple, save the record and close the form. I have struggling with the cancel button vba though. I want it to first, discount any...

Perfect, Thank you!!

Just go to it, I still want them to be able to use the navigation controls.