calendar box on form

S

shank

I have a form with a dropdown box for calendar popup. OnMouseDown, calendar
appears and OnClick, it populates combo box frmBoxDatteDue and disappears.
Great!

However, when I submit the form and run a query, that combo box does not
provide data to the query. Why?

All the other boxes on the form work fine.

This syntax does not cause any error: [Forms]![frmNewPO]![frmBoxDatteDue]

Query: INSERT INTO PO ( PONo, Company, Factory, Datte, DatteDue )
SELECT [Forms]![frmNewPO]![frmBoxPrefix] & Format(Now(),"yy") &
Format(Now(),"mm") & Format(Now(),"hhnn") AS PO,
[Forms]![frmNewPO]![frmBoxCompany] AS Company,
[Forms]![frmNewPO]![frmBoxFactory] AS Factory, Now() AS OpenDatte,
[Forms]![frmNewPO]![frmBoxDatteDue] AS DateDue;

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

list box 2 columns 1
Check box to control editablility of text box and return all recor 1
Calendar Form 15
two questions on exporting from a form 3
OnClick on Combo Box opens a New Form 0
List box selection into combo box 2
Combo Box Dependent on previous 7
Filter combo box in subform based on field in main form 1

Top