Form to Query - Data Type

[bdotr22]

Hi,

I have a form linked to a query where I type in a number and a date and then I want the query to use them.

I have designed a query that takes the data in fine, when it is all set as general.

When I set the field on the form to number then the query shows the related field as blank (changing the query field to number also doesn't seem to change anything), same thing with the date field.

I am sure it is something basic but I haven't really uses access for a decade and I am a bit lost! Any help would be great.

Thanks

[jojowhite]

it's is hard to guess without seeing what you have done so far (upload your db).

[bdotr22]

it's is hard to guess without seeing what you have done so far (upload your db).

When I try to attach it says file size is too large, is there something else I can do to upload?

[jojowhite]

compress it to .zip and upload the zip file.
please mention which form name you are having problem with.

[bdotr22]

Production Manager.zip

I shoud have thouyght of that...thanks!

I am looking at frmRPCreate which ties into qryItemList.

In this state it works. If I try to set the quantity field on the form to Number, or set the Due Date field to Date is where the issues arrise.

[June7]

I get an "invalid file" error trying to open your zip folder. Did you use Windows Compression?

[bdotr22]

Production Manager v2.zip

Yes, just Send To - Compressed File. When I download the previous attachment it become invalid also so trying again

EDIT : Same issue with these. Will try something else!

I think this works! Production Manager v3.zipProduction Manager v4.zip

[jojowhite]

see the changes i made on the form in design view.
also see the code (change event) on the Date textbox and Qty textbox.

[bdotr22]

see the changes i made on the form in design view.
also see the code (change event) on the Date textbox and Qty textbox.

I am now getting the invalid file error with this one!

[Welshgasman]

I am now getting the invalid file error with this one!

Me too. Added more characters to get past the stupid character count limit.