Imdabaum
04-27-2010, 02:30 PM
I've done this before, but for some reason this isn't returning a record.
I have certain data that I place on an InputForm. After I'm done there is additional information that gets put into another table but relating to that same company.
So on the inputform, I have a button to open the next form:Form2.
Form2 has the following query as it's record source:
SELECT Table1.[Record#],Table1.[Company#],Table1.[Input Date]
FROM Table1
WHERE (((Table1.[Company#])=[Forms]![InputForm]![Company#]))
ORDER BY Table1.[Input Date];
When I open the query I see the record that corresponds to the InputForm's company#. But the form displays without any of the query results with a recordcount of 1 and no data shows.
I am using Access 2003 with a SQL Server backend, in case that makes a difference.
I have certain data that I place on an InputForm. After I'm done there is additional information that gets put into another table but relating to that same company.
So on the inputform, I have a button to open the next form:Form2.
Form2 has the following query as it's record source:
SELECT Table1.[Record#],Table1.[Company#],Table1.[Input Date]
FROM Table1
WHERE (((Table1.[Company#])=[Forms]![InputForm]![Company#]))
ORDER BY Table1.[Input Date];
When I open the query I see the record that corresponds to the InputForm's company#. But the form displays without any of the query results with a recordcount of 1 and no data shows.
I am using Access 2003 with a SQL Server backend, in case that makes a difference.