Insert Into single record

[DuMont]

I currently have a command button to run the following...

DoCmd.OpenQuery "Credit Card Report", , acAdd

Which is an appended query.

However, I don't want it to add the whole table each time this is pushed but when trying to use...

DoCmd.RunSQL "INSERT INTO [Credit Cards] ([Provider's Name], [Patient Name], [Patient Account Number] ... VALUES ([Provider's Name.Value], [Patient Account Number.Value], [Patient Account Number.Value]"

It doesn't want to add the single record and gives me an error. I'm pretty sure my syntax is wrong but not sure how to correct it.

The fields I want added are ... Provider's Name , Patient Name, Patient Account Number

Any help would be greatly appreciated!

 

[spikepl]

And the text of the error message you've decided to keep secret because ...? Just to make it more challenging or what exactly?

When a asking for help on a specific statement, then "..." has no business in it either. Provide the entire thing for us to abuse, or perhaps even rectify.

 

[DuMont]

I'm pretty sure my syntax is wrong but not sure how to correct it.

Syntax error.

The "..." is because I have 20+ fields - why would I post all of them? If can get the first 3 to work, more than likely able to make the rest work.

Thanks for reply though.

 

[spikepl]

Good luck then

 

[DuMont]

You too big guy.