Queries heads

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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;
 
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
 
Back
Top