Text Box to Table

[Jollywg]

How would i go about taking the text out of txt1 and place it in a table with a column header textbox1 when i press cmd1

Thanks!

[janders468]

There are a few ways you could do it, but I would probably place this into the click event for the button:

    DoCmd.RunSQL "INSERT INTO tablename (textbox1) SELECT '" & me.txt1 & "'";
 

[Jollywg]

There are a few ways you could do it, but I would probably place this into the click event for the button:

    DoCmd.RunSQL "INSERT INTO tablename (textbox1) SELECT '" & me.txt1 & "'";
 

Thanks for the help that worked wonderfully. Now my next question is how do i get a name from a query to the textbox?

[janders468]

It depends on the query, could you post the sql for your query and I'll incorporate that into an example on how to do it.

[Jollywg]

It depends on the query, could you post the sql for your query and I'll incorporate that into an example on how to do it.

Here is the query

SELECT MasterZip.Territory AS Territory, Count(MasterZip.[ZIP Code]) AS [CountOfZIP Code], Sum(MasterZip.MVRs) AS SumOfMVRs, Sum(MasterZip.Outlets) AS SumOfOutlets
FROM MasterZip
GROUP BY MasterZip.Territory
HAVING (((Left([MasterZip].[Territory],4))=[Please enter the Territory Number]));

[janders468]

I should also have asked, what field are you interested in populating the textbox with?

[Jollywg]

I should also have asked, what field are you interested in populating the textbox with?

the textbox names are txtTerritory, txtMVR, txtOutlets. Is this what you're talking about?

[janders468]

Using a parameterized query makes this difficult, but typically if all you are returning is one value then I find a dlookup the best way to go. A dlookup takes two required parameters and one optional. The first is the field that contains the value you are interested in, the second is the table or query the field is contained within, and the the third is an optional criteria, it then returns the value from the field you specified in the first argument based on the result set of the query. In your case you can use your existing query. The only change you would have to make is instead of passing it the parameter of [Please Enter the territory number] you will need to give it that value such as from a textbox or some other input control on the form, then place the value of that control in your HAVING clause

HAVING (Left([MasterZip].[Territory],4))= RelevantControlValue));
 

Assuming that once this query is constrained to a territory it only returns one record then you can return any value from any of the fields for instance (assume your query is named query1):

txtTerritory = dlookup("[Territory]","Query1")
 

[Jollywg]

ok I'll give it a try. Thanks!

[janders468]

Let me know if you have questions, there are several simple things that could cause this to fail, so if it doesn't work we can certainly work through that.