Help With A-Level ICT Coursework

[Rgaming]

Need a value to be inputted into a table



Video: https://www.youtube.com/watch?v=6SM3RLLV4VA
Code:
Private Sub Command46_Click()
DoCmd.OpenTable "Payment", acViewNormal, acEdit
DoCmd.GoToRecord , , acNewRec
Payment_ID = Next_Payment_ID
End Sub

Other option: https://www.youtube.com/watch?v=UTB2eXkSurM
Code which opens a form and presses a button.

Thank for any help

[aytee111]

We do not watch videos to answer questions. Tell us exactly what you are trying to achieve and where your problem lies.

[June7]

I usually can't even open youtube videos but I took a chance and was able to view the first one. The video is not a solution, it is presenting a question on non-functioning code. I think that person has built a form with query that joins two tables and is attempting to populate data into both instead of using a form/subform arrangement. Whatever, seems to be a really screwed up design.

Can't set value directly into field of table like that.

Suggest you NOT try to implement non-functioning design and code in the future.

Not even going to give in to curiosity about the second video.