select statement inside values?

[hung_ko]

I am new to Access.
I wonder if i can have multiple statements from different tables when i do insert

the following code doesn't work, but this is what i need to do:

INSERT INTO waveform
( waveform_title_tx, [Frequency Modulation], [Frequency Rate])
VALUES


('TEST',
[select freq_modulation_id_cd from freq_modulation where freq_modulation_title_tx = 'AM'],
[select bandwidth_rate_id_cd from bandwidth_rate where bandwidth_rate_title_tx = 'MHz']);

anyone who can help? thank you

[pbaldy]

It would probably be simplest to use a DLookup for each of those values.

[hung_ko]

thank you for the help, Paul.

[pbaldy]

Happy to help, and welcome to the site by the way!

[hung_ko]

thanks, man