Append Query using a Form is not appending a number.

[jarrodf43]

I have a form called New Projects that has a combo box for Customers (it pulls from a Customer table with Customer ID, FirstName and LastName). Then I have a Project Description (txtDescription) field, and Amount field (currently set to Standard number with 2 decimal places, and I have a Project Note field (255 characters) for describing the project. When I do my append query to pull from these unbound fields in the form, I get everything but the amount? What gives?



Here's is the SQL for my query:

INSERT INTO tblProjects ( CustomerID, Description, Amount, [Project Notes] )SELECT [Forms]![New Project]![cmbCustomer] AS Customer, [Forms]![New Project]![txtDescription] AS Description, [Forms]![New Project]![txtAmount] AS Amount, [Forms]![New Project]![txtNotes] AS [Project Notes];

Thanks!

[pbaldy]

Curious. You're not running the query with focus still on the amount textbox, are you? The value won't have been committed. Make sure the textbox has a numeric format, in case that might screw it up.

Any reason you don't just use a bound form?

[jarrodf43]

Thanks! I was trying to preview the results without actually running the query. When I ran the query it worked. Can you tell me the pros and cons of a bound form versus unbound?

[pbaldy]

Jason has some thoughts here:

http://www.baldyweb.com/BoundUnbound.htm