Assign information from Query to a Form Field
Hi I am having an issue with trying to populate information from a query with a single line into a field in a form. Can someone let me know what I am doing wrong with my Code? Private Sub Form_Load() strsql = "SELECT SelectionID, SalesAdministrator, Customer, Week, Commodity FROM FilterCriteria WHERE (SelectionID)=1 ;" x = InputBox("", "", "' & strsql.Customer & '") Me.Combo58.Value = "' & strsql.Customer & '" Me.WeekCombo.Value = "' & strsql.Week & '" Me.CommodityCombo.Value = "' & strsql.Commodity & '" DoCmd.Requery End Sub It is to populate these fields which are blank at the top. You can see it is not putting the value of the query field in the first field. First field should be Text, Second field is a number and third field is text. I would really appreciate some help. Thanks Aaron
