Enter Parameter Value

[weircolin]

Hi there

I have a query which has the following in the SQL

INSERT INTO Atendee ( Person, Event )
SELECT FirstName+' '+LastName AS Person, Forms!eventgenerate!
cboselectevent AS Event
FROM [Members Names];

When the form containing cboselectevent is open and I use the combo
box to select a value, when I press the button to run this query I get
is asking to enter the parameter value for Forms!eventgenerate!
cboselectevent. Does anyone have a solution? It was working fine,
but decided to stop now!

Cheers

Colin

 

[John W. Vinson]

That would be great!

Not sure what code you require however.

This is the quey SQL

INSERT INTO Atendee ( Person, Event )
SELECT FirstName+' '+LastName AS Person, Forms![Add New Event]!
eventgenerate!cboselectevent AS Event
FROM [Lanarkshire Links members];

Thanks

Colin

The Attendee table *DOES NOT CONTAIN* a text field into which you can insert
FirstName + ' ' + LastName. At least it shouldn't contain such a field.

It may *appear* to contain such a field, if you've fallen victim to the
infamous Lookup Wizard's mischief.

What the Attendee table actually contains is *A NUMBER* - a link to the Person
table.

Try

INSERT INTO Atendee (Person, Event)
SELECT Person.PersonID, FOrms![Add New
Event]!eventgenerate.Form!cboSelectEvent
FROM [Lanarkshire Links Members];

This is making some possibly unwarrented assumptions about the structure of
your tables and forms, but in essence you need to insert a numeric ID, not a
name.