Queries heads

  • Thread starter Βάππας Κωνσταντίνος
  • Start date
Î

Βάππας Κωνσταντίνος

I have a select query but when i view it in datasheet view or in a list box
it doesn't display new heads but these which fields have from table.

SELECT Insurer.InsurerName AS Ασφαλιστής,
ApplicationForm.ApplicationFormNumber AS [ΑÏιθμός αίτησης],
Mid([ApplicationFormNumber],1,9) AS ΑΦΜ, ApplicationForm.Branch AS Κλάδος,
ApplicationForm.InsuredName AS Ασφαλισμένος,
ApplicationForm.ApplicationFormDate AS ΗμεÏομηνία
FROM Insurer INNER JOIN ApplicationForm ON Insurer.InsurerID =
ApplicationForm.InsurerID
WHERE (((ApplicationForm.ApplicationFormNumber) Like
[Forms]![InsertApplicationFormNumber]![InsertApplicationFormNumber] & "*"))
ORDER BY ApplicationForm.ApplicationFormDate;
 
M

Michel Walsh

Hi,


If you, or someone else, or your VBA code, added records in the table(s)
SINCE the statement was executed, and you wish to see the new stuff, ...
re-issue the command. In the case of a control with a RowSource, use:


Me.ControlName.RowSource = Me.ControlName.RowSource



Hoping it may help,
Vanderghast, Access MVP
 
Top