Updating a table from a form

[roglejr94]

I have a table (TableA) that I update certain records via it manually from a form (FormB).

Open FormA and enter a ticket# and click FIND.


FormB opens with certain fields preloaded from TableA. (All the fields on FormB come from TableA and the ones that are BLANK are suppose to be that way at this time.)
What I want to do is default current date into TableA.DateEnteredPaid and current user into TableA.EnteredPaidBy and "PAID" into TableA.Disposition and then update them when I save the record/exit FormB.

How would I do it? (Access newbie here)

Thanks in Advance!
T-Rex

[June7]

Will require code (macro or VBA) - I use only VBA.

This is adding data to an existing record or default values for a new record?

[nick404]

select the table in the navigation pane (left side bar) and click create form. Will make the form with the table as the record source so it is tied to your table. Will automatically generate textboxes and labels for every field in your table. You can delete which ones you do not want, and switch some to combo boxes or list boxes if you want.

[nick404]

The FIND function you want will be a query that will have the Criteria as [Enter Ticket #], the user will be prompted to enter the number and it will return information on that record.

[roglejr94]

I have the table already created and using it but I want a couple fields to default current date and user into the table.

[June7]

Does not answer my question.

Set the DefaultValue property for the DateEnteredPaid to Now() or Date() and that field will be automatically populated for a new record.

Setting default for EnteredPaidBy will require code.

Setting value for either in an existing record will require code.

[roglejr94]

Both exist in the TableA so I need to code for them but I have no idea on that. I prefer RPG on the iSeries than Access. LOL

[June7]

What is 'RPG on the iSeries'?

Still have not directly answered my question from post 2.

How do you know who 'current user' is? Do you have a login procedure? Or do you want to pull username from network login?

[roglejr94]

RPG on the iSeries: If I have to explain then it's a mute point.

As my initial post that started this thread says: UPDATE records